Dear,
How is it possible to sort different dimensions in a pivot table based on 1 expression?
If I sort it via the sort tab in Qlik Sense, and I choose to sort on expression, then the lower dimensions are not sorted themselves, but they follow the sorting of the highest dimension (I need sort them on the same expression).
Now Qlik Sense gives me the following output:
Category: item nr: Measure:
A item 3 300
item 1 200
item 2 100
B item 3 10
item 1 20
item 2 30
C item 3 2
item 1 1
item 2 3
Actually I need the following output:
Category: item nr: Measure:
A item 3 300
item 1 200
item 2 100
B item 2 30
item 1 20
item 3 10
C item 2 3
item 3 2
item 1 1
How can I solve this issue?
Thanks in advance.
Kind regards,
Ignace Devreese
