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.
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.
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.
Information noteIf 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.
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.
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.
Information noteIf qSuppressOther is not defined, the last value in the visualization (colored gray), summarizes all the remaining values.
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.
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.