Pivot Table: Sort By ExpressionArticle Number: 000027033 | Last Modified: 2019/07/18
For example as in example below where second dimension is sorted by the same expression as the chart expression.
The expected result is that second dimension is sorted by the expression result.
Notice, the above expected result is a fake image. This chart can not be generated in QlikView, as described below.
- QlikView all versions
- Qlik Sense all versions
In a pivot table the values in a dimension are naturally grouped over the previous dimension. For most intuitive end-user experience the values are sorted in identical order in each group. For this reason the example in this case gets sort order a-c-b for the second dimension, which leads to the sort not appearing to follow the expression results.
An expected result where the grouped value have different sort order can not be accomplished with the native pivot table object.
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.