QlikView App: PIVOT TABLE DYNAMIC SORTING BY MULTIPLE MEASURES

[waszcma1]

Hi I would like to share with you something which I thing can be very useful.

Many times I was asked how can pivot table in QV can be sorted and why can't we do the same way as it is done in straight table (by double click on the label)?

I was searching for the solution and most of them are quite complex or required macro which frankly saying I do not like very much.

So when you open the app (attached) you will find my approach to this problem. I haven't used any macro codes.

I had to use variable and Trigger in document properties 

Whats more the sorting list is dynamic so reflect actual view of the measures in the table.