topic Re: Sorting pivot table dropdown selection in QlikView https://community.qlik.com/t5/QlikView/Sorting-pivot-table-dropdown-selection/m-p/1137295#M373128 <HTML><HEAD></HEAD><BODY><P>No problem. Make the change in the file .qvw, then deploy it on the server.</P></BODY></HTML> Wed, 18 May 2016 20:49:53 GMT jonas_rezende 2016-05-18T20:49:53Z Sorting pivot table dropdown selection https://community.qlik.com/t5/QlikView/Sorting-pivot-table-dropdown-selection/m-p/1137290#M373123 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with a dropdown selector for year and quarter.&nbsp; Is there any way to change the sort to be descending by year and quarter?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/124459_pastedImage_0.png" /></P><P></P><P>It's based on a drilldown dimension:</P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/124475_pastedImage_1.png" /></P></BODY></HTML> Thu, 12 May 2016 20:26:16 GMT https://community.qlik.com/t5/QlikView/Sorting-pivot-table-dropdown-selection/m-p/1137290#M373123 2016-05-12T20:26:16Z Re: Sorting pivot table dropdown selection https://community.qlik.com/t5/QlikView/Sorting-pivot-table-dropdown-selection/m-p/1137291#M373124 <HTML><HEAD></HEAD><BODY><P>Hi, Scoot Green.</P><P></P><P>The fields year and quarter are as dimension in pivot table?</P><P></P><P>Regards,</P><P></P><P>Jonas Melo.</P></BODY></HTML> Fri, 13 May 2016 12:00:49 GMT https://community.qlik.com/t5/QlikView/Sorting-pivot-table-dropdown-selection/m-p/1137291#M373124 jonas_rezende 2016-05-13T12:00:49Z Re: Sorting pivot table dropdown selection https://community.qlik.com/t5/QlikView/Sorting-pivot-table-dropdown-selection/m-p/1137292#M373125 <HTML><HEAD></HEAD><BODY><P>Hi Jonas, sorry I didn't get back to you right away; but I was on vacation.</P><P></P><P>Yes the Year and Quarter are dimensions in the pivot table.</P></BODY></HTML> Tue, 17 May 2016 15:19:14 GMT https://community.qlik.com/t5/QlikView/Sorting-pivot-table-dropdown-selection/m-p/1137292#M373125 2016-05-17T15:19:14Z Re: Sorting pivot table dropdown selection https://community.qlik.com/t5/QlikView/Sorting-pivot-table-dropdown-selection/m-p/1137293#M373126 <HTML><HEAD></HEAD><BODY><P>Hi, Scott Green.</P><P></P><P>In Desktop version, follow the steps below:</P><P></P><OL><LI>Menu Settings, Groups tab;</LI><LI>Choose the group desired and click button Edit;</LI><LI>Click in button Sort Orders;</LI><LI>Change the classification of your field.</LI></OL><P></P><P>Hope this helps!</P></BODY></HTML> Wed, 18 May 2016 13:01:07 GMT https://community.qlik.com/t5/QlikView/Sorting-pivot-table-dropdown-selection/m-p/1137293#M373126 jonas_rezende 2016-05-18T13:01:07Z Re: Sorting pivot table dropdown selection https://community.qlik.com/t5/QlikView/Sorting-pivot-table-dropdown-selection/m-p/1137294#M373127 <HTML><HEAD></HEAD><BODY><P>Hi Jonas,</P><P></P><P>Thanks for the input; but I'm running the Enterprise Server version.</P></BODY></HTML> Wed, 18 May 2016 18:56:46 GMT https://community.qlik.com/t5/QlikView/Sorting-pivot-table-dropdown-selection/m-p/1137294#M373127 2016-05-18T18:56:46Z Re: Sorting pivot table dropdown selection https://community.qlik.com/t5/QlikView/Sorting-pivot-table-dropdown-selection/m-p/1137295#M373128 <HTML><HEAD></HEAD><BODY><P>No problem. Make the change in the file .qvw, then deploy it on the server.</P></BODY></HTML> Wed, 18 May 2016 20:49:53 GMT https://community.qlik.com/t5/QlikView/Sorting-pivot-table-dropdown-selection/m-p/1137295#M373128 jonas_rezende 2016-05-18T20:49:53Z