Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to order pivot table by a total field


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

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

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.