Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to order pivot table by a total field

Hi,

I 've attached my real file to finally know if it is possible to order 'TTOO' descending by 'TOTAL W + S' -->'Prod.'

Thank you all

2 Replies
Gysbert_Wassenaar

Try not sorting HOT on Y-Value and sorting TTOO descending on =sum(I_PRODUCCION). As far as I can tell that sorts the table like you want.


talk is cheap, supply exceeds demand
Not applicable
Author

I'm sorry I should have attached an exemple with several HOT.

You are right with the exemple I attached it shows the right order, but , when there are several 'HOT' how could I get the right descending order into each HOT? maybe I have to use 'aggr' but I do not understand exactly how.

Thanks