Discussion Board for collaboration related to QlikView App Development.
Hi could you help me create the right expression to sort data in pivot table
At the moment I am using SUM(Ammount) in sort by Expression [Descending]
But it works only on total or only for one year selected
I would force sorting always on the last period visible in the pivot table in this example 2019 amounts should sort the records.
There are also hidden view for different periods like Year-Quarter, Year-Monht, Quarter, Month
I think i have found solution:
To sort pivot by only latest year I need to use Set analysis in sort by expression:
Similar for others periods but always just take only max of the displayed period
View solution in original post
Please share the sample application