Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion Board for collaboration related to QlikView App Development.
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
View solution in original post
