Discussion board where members can get started with Qlik Sense.
I Have ש pivot table with three dimensions and one expression,
the table is fully expanded and the third dimension shows only top 10.
I want that the third dimension will be in descending order by the expression.
Go to Solution.
For the second and third dimension, please replace them with the following respectively:
That will make each value unique within each subgroup
I hope this helps,
Please try and let me know,
Go to the sort tab; go to ur 3rd dimension;
sort it by expression; tap the measure u're using and sort it as descending:
Thanks for the advise, unfortunately it isn't working.
If the values in your dimensions can appear in different groups then the solution that Omar is showing may need some tweaking. Can you share a bit more about it?
Yes, The third dimension can appear more than once for example
Shop Group Item Qty
A I X 54
B I X 85
II S 55
Thanks, but still not working
you might forgot to mention: sum(qty) any where?
Yeap you're right. I'm assuming you're following Omar's recommendation (Sorting by expression with Sum, etc.)
It's the same that Omar said but the 2nd and 3rd dimensions on your Pivot Table needed to be changed
Please try and let me know
Tried without a success.
Hehe, not like that,
Is it possible for you to share data?