Applying dimension limits

Dimension limits is defined in the qOtherTotalSpec object and specifies if some values, grouped as Others, should be grouped together in the visualization. This limits the number of displayed values and when such limitation is set, the only dimensions displayed are those where the measure value meets the limitation criterion.

Fixed number: Select to display the top or bottom values. Set the number of values. You can also use an expression to set the number.
Exact value: Use the operators and set the exact limit value. You can also use an expression to set the number.
Relative value: Use the operators and set the relative limit value in percent. You can also use an expression to set the number.

The qOtherTotalSpec object

Dimension limits are set in the qOtherTotalSpec object. The object resides inside the dimension definition which means that each dimension of a hypercube is configured separately.

"qOtherTotalSpec": { "qOtherMode": "OTHER_COUNTED", "qOtherCounted": { "qv": "6" }, "qOtherLimit": { "qv": "0" }, "qOtherLimitMode": "OTHER_GE_LIMIT", "qOtherSortMode": "OTHER_SORT_DESCENDING", "qTotalMode": "TOTAL_OFF" }

Example: qOtherTotalSpec formatted to limit on the top 6 values (including others) of the first measure

Sets the dimension limit mode to be used.

OTHER_OFF: no limitation is applied to the dimension.
OTHER_COUNTED: dimension limit set to display a fixed number defined in qOtherCounted, calculated on the first measure.
OTHER_ABS_LIMITED: dimension limit set to display an exact value defined in qOtherLimit, calculated on the first measure.
OTHER_ABS_ACC_TARGET: dimension limit set to display values that accumulate to an absolute value. All rows up to the current row are accumulated and the result is compared to the specified absolute value. The absolute value is defined in qOtherLimit.
OTHER_REL_LIMITED: dimension limit set to display values based on a relative value of the total of the first measure. The percentage is defined in qOtherLimit.
OTHER_REL_ACC_TARGET: dimension limit set to display values that accumulate to a percentage of the total. All rows up to the current row are accumulated and the result is compared to the total of the dimension values. A percentage is calculated and this percentage is compared to the specified percentage, defined in qOtherLimit.

Default: OTHER_OFF

Sets the number of values to display when "qOtherMode": "OTHER_COUNTED". The number of values can be entered as a string or as a calculated formula.

"qOtherTotalSpec": { "qOtherMode": "OTHER_COUNTED", "qOtherCounted": { "qv": "Sum(3+2)" }, "qOtherSortMode": "OTHER_SORT_DESCENDING" }

qOtherCounted defined as an expression

Sets the number of values to display when "qOtherMode": "OTHER_ABS_LIMITED", "qOtherMode": "OTHER_REL_LIMITED", "qOtherMode": "OTHER_ABS_ACC_TARGET" or "qOtherMode": "OTHER_REL_ACC_TARGET".

The number of values can be entered as a string or as a calculated formula. Inequality relation is defined in qOtherLimitMode.

Sets the inequality relation to the value of qOtherLimit. Use this parameter when "qOtherMode": "OTHER_ABS_LIMITED", "qOtherMode": "OTHER_REL_LIMITED", "qOtherMode": "OTHER_ABS_ACC_TARGET" or "qOtherMode": "OTHER_REL_ACC_TARGET".

Can be one of:

OTHER_GE_LIMIT: include the values greater than or equal to what is defined in qOtherLimit.
OTHER_LE_LIMIT: include the values lower than or equal to what is defined in qOtherLimit.
OTHER_GT_LIMIT: include the values strictly greater than what is defined in qOtherLimit.
OTHER_LT_LIMIT: include the values strictly lower than what is defined in qOtherLimit.

Default: OTHER_GT_LIMIT

Set to true to omit the group Others as a dimension value.

Default: false

Includes text values in the returned values. Use this parameter when "qOtherMode": "OTHER_ABS_LIMITED", "qOtherMode": "OTHER_REL_LIMITED", "qOtherMode": "OTHER_ABS_ACC_TARGET" or "qOtherMode": "OTHER_REL_ACC_TARGET" and when dimension values include non-numeric values.

Default: true

Allows the calculation of Others even if the Qlik associative engine detects some potential mistakes.

Default: true

This parameter applies to inner dimensions. When set to true, the restrictions are calculated on the selected dimension only. All previous dimensions are ignored.

Default: false

If set to true, it collapses the inner dimensions (if any) in the group Others.

Default: false

Defines the sort order of the dimension values. Can be one of:

OTHER_SORT_DEFAULT: sort by load order
OTHER_SORT_DESCENDING: sort by descending values
OTHER_SORT_ASCENDING: sort by ascending values

Default: OTHER_SORT_DESCENDING

Sets if the total of the dimension values should be included. Can be one of

TOTAL_OFF: no total returned
TOTAL_EXPR: include total

Default: TOTAL_OFF

This parameter applies when there are several measures.

Defines the measure to use for the calculation of Others for a specific dimension.

Fixed number limitations

These examples helps you set numbers to display the top or bottom values. You can also use an expression to set the number.

Example: fixed number, top 3, no others

In this example we want to display only the top three results based on the first measure. So we set "qOtherMode": "OTHER_COUNTED" and we then define "qOtherCounted": {"qv": "3"}. We do not want to show an others value, so we set "qSuppressOther": true.

If qSuppressOther is not defined, the last value in the visualization (colored gray), summarizes all the remaining values and the value counts as 1 in that setting. In this example, the third value would be Others.

Since we want to show the top (highest) three values we set "qOtherSortMode": "OTHER_SORT_DESCENDING" to sort the values in descending order.

"qOtherTotalSpec": { "qOtherMode": "OTHER_COUNTED", "qOtherCounted": { "qv": "3" }, "qSuppressOther": true, "qOtherSortMode": "OTHER_SORT_DESCENDING" }

Example: fixed number, top 3, show others labeled "Other venues"

The below examples are variants of the above example, where one example include others and another example shows the bottom three values.

The label for others are set in the othersLabel property inside the NxInlineDimensionDef (qDef). In the qOtherTotalSpec object, set "qSuppressOther": false, or omit it completely.

{ "qDef": { "qFieldDefs": [ "City" ], "othersLabel": "Other venues" }, "qOtherTotalSpec": { "qOtherMode": "OTHER_COUNTED", "qOtherCounted": { "qv": "3" }, "qOtherSortMode": "OTHER_SORT_DESCENDING" } }

Example: fixed number, bottom 3, no others

This example is a variant of the above example, where we show the bottom three with no others.

Set "qOtherSortMode": "OTHER_SORT_ASCENDING" to change the sort order and show the bottom three results.

"qOtherTotalSpec": { "qOtherMode": "OTHER_COUNTED", "qOtherCounted": { "qv": "3" }, "qSuppressOther": true, "qOtherSortMode": "OTHER_SORT_ASCENDING" }

Exact value limitations

These examples helps you use the operators and set exact limit values. You can also use an expression to set the number.

Example: exact value set to above or equal to 40000, no others

In this example we want to display all venues with an attendance average higher than or equal to 40,000.

We set "qOtherMode": "OTHER_ABS_LIMITED" to limit the dimension values to an absolute value. We then define the actual value "qOtherLimit": {"qv": "40000"}. We set "qOtherLimitMode": "OTHER_GE_LIMIT" to include the values greater than or equal to what we defined in qOtherLimit.

We do not want to show an others value, so we set "qSuppressOther": true.

If qSuppressOther is not defined, the last value in the visualization (colored gray), summarizes all the remaining values.

"qOtherTotalSpec": { "qOtherMode": "OTHER_ABS_LIMITED", "qOtherLimit": { "qv": "40000" }, "qOtherLimitMode": "OTHER_GE_LIMIT", "qSuppressOther": true }

Example: exact value set to less than 40000, no others

This example is a variant of the above example, where we display the venues with an attendance average less than 40,000.

Set "qOtherLimitMode": "OTHER_LT_LIMIT" to include the values less than what was defined in qOtherCounted.

"qOtherTotalSpec": { "qOtherMode": "OTHER_ABS_LIMITED", "qOtherLimit": { "qv": "40000" }, "qOtherLimitMode": "OTHER_LT_LIMIT", "qSuppressOther": true }

Relative value examples

These examples helps you use the operators and set relative limit values. You can also use an expression to set the number.

Example: relative value set to greater than or equal to 12%, no others

In this example we want to display all venues with an attendance average higher than or equal to 12 per cent of the total.

We set "qOtherMode": "OTHER_REL_LIMITED" to limit the dimension values to an relative value. We then define the actual value "qOtherCounted": {"qv": "12%"}. We set "qOtherLimitMode": "OTHER_GE_LIMIT" to include the values greater than or equal to what we defined in qOtherCounted.

We do not want to show an others value, so we set "qSuppressOther": true.

"qOtherTotalSpec": { "qOtherMode": "OTHER_REL_LIMITED", "qOtherLimit": { "qv": "12%" }, "qOtherLimitMode": "OTHER_GE_LIMIT", "qSuppressOther": true, "qOtherSortMode": "OTHER_SORT_DESCENDING" }

Example: relative value set to less than 11%, no others

In this example we want to display all venues with an attendance average less than 11 per cent of the total.

We set "qOtherMode": "OTHER_REL_LIMITED" to limit the dimension values to an relative value. We then define the actual value "qOtherCounted": {"qv": "11%"}. We set "qOtherLimitMode": "OTHER_LT_LIMIT" to include the values lower than what we defined in qOtherCounted.

We do not want to show an others value, so we set "qSuppressOther": true.

"qOtherTotalSpec": { "qOtherMode": "OTHER_REL_LIMITED", "qOtherLimit": { "qv": "11%" }, "qOtherLimitMode": "OTHER_LT_LIMIT", "qSuppressOther": true "qOtherSortMode": "OTHER_SORT_DESCENDING" }

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here