Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

QlikView App: PIVOT TABLE DYNAMIC SORTING BY MULTIPLE MEASURES

cancel
Showing results for 
Search instead for 
Did you mean: 
waszcma1
Creator
Creator

QlikView App: PIVOT TABLE DYNAMIC SORTING BY MULTIPLE MEASURES

Attachments

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.

Pivot Table 01.JPG

 

Version history
Last update:
‎2020-02-27 07:24 PM
Updated by:
Contributors