Operators

Use this operator to include entities where the value of the selected attribute matches the value or values you select.

For example, for the Country filter, if you select United Kingdom with the In list operator, the visualised group structure is filtered to include UK entities only.

With this operator, you can exclude entities where the value of the selected attribute matches the value or values you select.

For example, for the Country filter, if you select United Kingdom with the Not in list operator, the visualised group structure is filtered to include entities in all countries except the UK.

Use this operator to include entities where the selected attribute has any value.

For example, for the Sub-Country filter, if you select the Exists operator, the visualised group structure is filtered to include entities that have a region or state specified in their record.

With this operator, you can include entities where the selected attribute does not have a value.

For example, for the Sub-Country filter, if you select the Does not exist operator, the visualised group structure is filtered to include entities that do not have a region or state entered in their record.

Use this operator to include entities where the value of the selected attribute does not contain the value you enter.

For example, for the Name filter, if you select the Does not contain operator and enter Holdings, the visualised group structure is filtered to include entities that do not have Holdings in their name.

Does not end with

With this operator, you can include entities where the value of the selected attribute does not end with the value you enter.

For example, for the Name filter, if you select the Does not end with operator and enter Limited, the visualised group structure is filtered to include entities the name of which does not end with Limited.

Use this operator to include entities where the value of the selected attribute does not start with the value you enter.

For example, for the Name filter, if you select the Does not start with operator and enter External, the visualised group structure is filtered to include entities the name of which does not start with External.

Contains

With this operator, you can include entities where the value of the selected attribute contains the value you enter.

For example, for the Name filter, if you select the Contains operator and enter Fund, the visualised group structure is filtered to include entities the name of which contains Fund.

Ends with

Use this operator to include entities where the value of the selected attribute ends with the value you enter.

For example, for the Name filter, if you select the Ends with operator and enter Plc, the visualised group structure is filtered to include entities the name of which ends with Plc.

Starts with

With this operator, you can include entities where the value of the selected attribute starts with the value you enter.

For example, for the Name filter, if you select the Starts with operator and enter Public, the visualised group structure is filtered to include entities the name of which starts with Public.

Equals

Use this operator to include entities where the value of the selected attribute matches the value you enter.

For example, for the Name filter, if you select the Equals operator and enter My Company Plc, the visualised group structure is filtered to include entities with the My Company Plc name.

Not equal to

With this operator, you can exclude entities where the value of the selected attribute matches the value you enter.

For example, for the Name filter, if you select the Not equal to operator and enter My Company Plc, the visualised group structure is filtered to exclude the entities with the My Company Plc name.

In range

Use this operator to include entities where the value of the selected attribute is within the range you enter. This operator is inclusive, begin and end values are included.

For example, for the Interest Percentage filter, if you select the In range operator and enter 20 as begin value and 50 as end value for the range, the visualised group structure is filtered to include entities where the interest percentage is greater than or equal to 20% and less than or equal to 50%.

With this operator, you can include entities where the value of the selected attribute is outside the range you enter. This operator is not inclusive, begin and end values are not included.

For example, for the Interest Percentage filter, if you select the Outside range operator and enter 20 as begin value and 50 as end value for the range, the visualised group structure is filtered to include entities where the interest percentage is less than 20% and more than 50%.

In range (excluding right boundary)

Use this operator to include entities where the value of the selected attribute is within the range you enter. This operator only includes the begin value you enter.

For example, for the Interest Percentage filter, if you select the In range (excluding right boundary) operator and enter 20 as begin value and 50 as end value for the range, the visualised group structure is filtered to include entities where the interest percentage is greater than or equal to 20% and less than 50%.

With this operator, you can include entities where the value of the selected attribute is within the range you enter. This operator only includes the end value you enter.

For example, for the Interest Percentage filter, if you select the In range (excluding left boundary) operator and enter 20 as begin value and 50 as end value for the range, the visualised group structure is filtered to include entities where the interest percentage is greater than 20% and less than or equal to 50%.

In range (excluding boundaries)

Use this operator to include entities where the value of the selected attribute is within the range you enter. This operator is exclusive, begin and end values are not included.

For example, for the Interest Percentage filter, if you select the In range (excluding boundaries) operator and enter 20 as begin value and 50 as end value for the range, the visualised group structure is filtered to include entities where the interest percentage is greater than 20% and less than 50%.

Less than or equal to

With this operator, you can include entities where the value of the selected attribute is less than or equal to the value you enter.

For example, for the Interest Percentage filter, if you select the Less than or equal to operator and enter 50 as value, the visualised group structure is filtered to include entities where the interest percentage is less than or equal to 50%.

Use this operator to include entities where the value of the selected attribute is greater than or equal to the value you enter.

For example, for the Interest Percentage filter, if you select the Greater than or equal to operator and enter 50 as value, the visualised group structure is filtered to include entities where the interest percentage is greater than or equal to 50%.

Less than

With this operator, you can include entities where the value of the selected attribute is less than the value you enter.

For example, for the Interest Percentage filter, if you select the Less than operator and enter 50 as value, the visualised group structure is filtered to include entities where the interest percentage is less than 50%.

Use this operator to include entities where the value of the selected attribute is greater than the value you enter.

For example, for the Interest Percentage filter, if you select the Greater than operator and enter 50 as value, the visualised group structure is filtered to include entities where the interest percentage is greater than 50%.

Not equal to

With this operator, you can include entities where the value of the selected attribute does not match the value you enter.

For example, for the Interest Percentage filter, if you select the Not equal to operator and enter 50 as value, the visualised group structure is filtered to include entities where the interest percentage is not equal to 50%.

Use this operator to include entities where the value of the selected attribute is equal to the value you enter.

For example, for the Interest Percentage filter, if you select the Equals operator and enter 50 as value, the visualised group structure is filtered to include entities where the interest percentage is equal to 50%.

Is true

With this operator, you can include entities where the value of the selected attribute is TRUE.

For example, for the Overseas filter, if you select the Is true operator, the group structure is filtered to include overseas entities only.

Use this operator to include entities where the value of the selected attribute is FALSE.

For example, for the Overseas filter, if you select the Is false operator, the group structure is filtered to exclude overseas entities.