Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today

QlikView App: PIVOT TABLE DYNAMIC SORTING BY MULTIPLE MEASURES

Creator
Creator

QlikView App: PIVOT TABLE DYNAMIC SORTING BY MULTIPLE MEASURES

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

 

Attachments
Version history
Revision #:
1 of 1
Last update:
‎2020-02-27 07:24 PM
Updated by:
 
Contributors