I have a problem with sorting in pivot table (Qlik Sense). In the attachment I show what I mean.
I would like the expression to be sorted in descending order for each year. Is it possible?
You can sort by expression like this sample.
Changing the sorting of a visualization using expressions - Qlik Sense - YouTube
Thanks for Your answer.
But, unfortunately, in my case it didn't work.
It works for first year in pivot table. Subsequent years are sorted according to the order of the first year (regardless of value).
Sort by Year descending order
I tried probably all available default sorting options (and few expressions). I could not sort every year (1 dim) in a pivot table separately.
You can try to do this exercise in Qlik Sense (Years and Product in dimmensions, sum (sales) in measures).
Retrieving data ...