Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bimala0507
Partner - Creator
Partner - Creator

Enforce sorting in Pivot table

Dear experts:

I have a pivot table, with 3 dimensions and 2 measures. One of my dimension is calculated dimension and one of the measure has set analysis. I want to sort by simple expression SUM(amount) which is one of the measure. It does not work. I have encountered this many times, don't know why. How do you enforce the sorting in that case?

Kind Regards,

Bimala

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try the Sort by Y-value option. Enable that for the first chart dimension.


talk is cheap, supply exceeds demand