Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
It is imposible, if your pivot table have more one dimension
Is there still no work-around for this problem?