Discussion Board for collaboration related to QlikView App Development.
I already have a pivot table below:
Ignoring the Item column. I would like to sort the two fields separately from largest to smallest (desc), based on the 'Hours Late' field first and then the 'Hours Left' field:
Please let me know if it is doable. If yes, how? Or will i have to sort it in the load script file.
Would an ideal workaround be to use a regular table instead?
Go to Solution.
This pivot table:
Has the dimension Item sorted by this expression
1000*Sum([Hours Late])+Sum([Hours Left])
hi Fer Fer,
thanks for responding. 'Sorting by Y value' only sorts the first column for me, but not the 'Hours Left Column'. How did you achieve yours?
-Expressions: 'Hours Left' and 'Hours Late'this is what i did: right clicked on pivot table >>> Sort >>>Selected Item >>> Checked Y-value >>> Descending