https://community.qlik.com/t5/Member-Articles/QlikView-App-PIVOT-TABLE-DYNAMIC-SORTING-BY-MULTIPLE-MEASURES/ta-p/1680128 <P>Hi I would like to share with you something which I thing can be very useful.</P><P>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)?</P><P>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.</P><P>So when you open the app (attached) you will find my approach to this problem. I haven't used any macro codes.</P><P>I had to use variable and Trigger in document properties&nbsp;</P><P>Whats more the sorting list is dynamic so reflect actual view of the measures in the table.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Pivot Table 01.JPG" style="width: 557px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/29273iC7E5C46954F1C426/image-size/large?v=v2&amp;px=999" role="button" title="Pivot Table 01.JPG" alt="Pivot Table 01.JPG" /></span></P><P>&nbsp;</P> Wed, 21 Sep 2022 17:07:35 GMT waszcma1 2022-09-21T17:07:35Z https://community.qlik.com/t5/Member-Articles/QlikView-App-PIVOT-TABLE-DYNAMIC-SORTING-BY-MULTIPLE-MEASURES/ta-p/1680128 <P>Hi I would like to share with you something which I thing can be very useful.</P><P>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)?</P><P>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.</P><P>So when you open the app (attached) you will find my approach to this problem. I haven't used any macro codes.</P><P>I had to use variable and Trigger in document properties&nbsp;</P><P>Whats more the sorting list is dynamic so reflect actual view of the measures in the table.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Pivot Table 01.JPG" style="width: 557px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/29273iC7E5C46954F1C426/image-size/large?v=v2&amp;px=999" role="button" title="Pivot Table 01.JPG" alt="Pivot Table 01.JPG" /></span></P><P>&nbsp;</P> Wed, 21 Sep 2022 17:07:35 GMT https://community.qlik.com/t5/Member-Articles/QlikView-App-PIVOT-TABLE-DYNAMIC-SORTING-BY-MULTIPLE-MEASURES/ta-p/1680128 waszcma1 2022-09-21T17:07:35Z