Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
May 10, 2022 3:23:50 PM
Dec 29, 2017 10:23:47 AM
Sorting is incorrect when a user tries to sort with the second dimension. This happens in the case where 2 nested levels contain the same field name.
QlikView
Qlik Sense Enterprise on Windows
Qlik Cloud
Qlik Sense Business
Using the attached sample app, the pivot table has 2 nested levels contain the same field name: 'Income'.
If a user tries to sort with 'dimb' using 'dimbnum' in an expression. The sort works as expected for nested group 'A', but it works incorrectly for group 'B'.
It seems like 'Income' for group ' B' is ignored and the 'Income' in group 'A' is used in both groups.
Steps to reproduce:
This is working as designed. In the pivot table dima will be sorted before dimb, income will get the value 5000 (when sorted by the expression dimbnum) which is used when dimb is sorted, hence the last position in the sorted table.