topic Sorting pivot by measure only max Year, or max month or max Year-month etc. in QlikView

Sorting pivot by measure only max Year, or max month or max Year-month etc.

waszcma1 — Fri, 22 Nov 2019 21:38:45 GMT

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

tripatiqv — Sat, 23 Nov 2019 07:51:20 GMT

Hi,

Please share the sample application

waszcma1 — Fri, 29 Nov 2019 20:11:45 GMT

HI,

I think i have found solution:

To sort pivot by only latest year I need to use Set analysis in sort by expression:

sum({<Year={$(=max(Year))}>}worker_cost)

Similar for others periods but always just take only max of the displayed period

favio220 — Tue, 14 Mar 2023 19:45:19 GMT

Excellent!

Thank you.