topic Re: Sort pivot table measure in App Development https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440657#M34833 <HTML><HEAD></HEAD><BODY><P>This is exctly what i suspect...</P></BODY></HTML> Thu, 09 Nov 2017 10:39:45 GMT micheledenardi 2017-11-09T10:39:45Z Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440644#M34820 <HTML><HEAD></HEAD><BODY><P>how to sort the measure "Worked Days" from the greatest to lowest into a pivot table on qliksense?</P><P><IMG alt="2017-11-08 16_19_21-KS IT Activities(Sviluppo) - Worked Request By Resource _ Fogli - Qlik Sense.png" class="jive-image image-1" src="/legacyfs/online/182563_2017-11-08 16_19_21-KS IT Activities(Sviluppo) - Worked Request By Resource _ Fogli - Qlik Sense.png" style="height: auto;" /></P></BODY></HTML> Wed, 08 Nov 2017 15:25:31 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440644#M34820 micheledenardi 2017-11-08T15:25:31Z Re: Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440645#M34821 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Go to the properties, click on request number dimension, then click sorting. Sort by expression Sum([Worked Days]) then you can choose ascending or descending.</P></BODY></HTML> Wed, 08 Nov 2017 16:12:06 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440645#M34821 Anonymous 2017-11-08T16:12:06Z Re: Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440646#M34822 <HTML><HEAD></HEAD><BODY><P>This not work with pivot table....</P></BODY></HTML> Wed, 08 Nov 2017 16:14:38 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440646#M34822 micheledenardi 2017-11-08T16:14:38Z Re: Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440647#M34823 <HTML><HEAD></HEAD><BODY><P>Chart properties&gt;Sorting&gt;Request Number&gt;Click back the Sorting "Auto" so it comes up as "Custom" Then tick the box that says "Sort by expression" in the box type Sum([Worked Days]) then choose descending. </P></BODY></HTML> Wed, 08 Nov 2017 16:15:09 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440647#M34823 Anonymous 2017-11-08T16:15:09Z Re: Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440648#M34824 <HTML><HEAD></HEAD><BODY><P>It's not as easy on pivot table... your solution works only with charts or straight table.</P><P><IMG alt="2017-11-08 17_17_13-KS IT Activities(Sviluppo) - Worked Request By Resource _ Fogli - Qlik Sense.png" class="jive-image image-1" src="/legacyfs/online/182581_2017-11-08 17_17_13-KS IT Activities(Sviluppo) - Worked Request By Resource _ Fogli - Qlik Sense.png" style="height: 402px; width: 620px;" /></P></BODY></HTML> Wed, 08 Nov 2017 16:18:32 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440648#M34824 micheledenardi 2017-11-08T16:18:32Z Re: Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440649#M34825 <HTML><HEAD></HEAD><BODY><P>With the data you provided, this method works. </P><P>Maybe the data you provided is different than the actual one you are using? </P><P></P><P><IMG alt="ss3.PNG" class="jive-image image-1" height="383" src="https://community.qlik.com/legacyfs/online/182585_ss3.PNG" style="height: 383px; width: 454.904px;" width="455" /></P></BODY></HTML> Wed, 08 Nov 2017 16:29:37 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440649#M34825 Anonymous 2017-11-08T16:29:37Z Re: Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440650#M34826 <HTML><HEAD></HEAD><BODY><P>Please try to do it with the attached app. For me doesn't work.</P></BODY></HTML> Wed, 08 Nov 2017 16:42:48 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440650#M34826 micheledenardi 2017-11-08T16:42:48Z Re: Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440651#M34827 <HTML><HEAD></HEAD><BODY><P>Any idea on how to achieve it ?</P></BODY></HTML> Thu, 09 Nov 2017 09:48:51 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440651#M34827 micheledenardi 2017-11-09T09:48:51Z Re: Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440652#M34828 <HTML><HEAD></HEAD><BODY><P>I think it is already sorted till month due to request number it is getting challenge. </P></BODY></HTML> Thu, 09 Nov 2017 10:05:56 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440652#M34828 prma7799 2017-11-09T10:05:56Z Re: Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440653#M34829 <HTML><HEAD></HEAD><BODY><P>Month or request number sorting are not important... the only sort i need is by Worked Days</P></BODY></HTML> Thu, 09 Nov 2017 10:22:39 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440653#M34829 micheledenardi 2017-11-09T10:22:39Z Re: Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440654#M34830 <HTML><HEAD></HEAD><BODY><P>Please check this ..</P><P></P><P>It is sorted...</P></BODY></HTML> Thu, 09 Nov 2017 10:28:54 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440654#M34830 prma7799 2017-11-09T10:28:54Z Re: Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440655#M34831 <HTML><HEAD></HEAD><BODY><P>no, Worked Days it's not sorted at request number level.. thanks for the help</P><P><IMG __jive_id="182678" alt="2017-11-09 11_31_32-Qlik Sense Desktop.png" class="jive-image image-1" src="/legacyfs/online/182678_2017-11-09 11_31_32-Qlik Sense Desktop.png" style="height: auto;" /></P></BODY></HTML> Thu, 09 Nov 2017 10:32:10 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440655#M34831 micheledenardi 2017-11-09T10:32:10Z Re: Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440656#M34832 <HTML><HEAD></HEAD><BODY><P>I think it is not taking 3 level of sorting ...<IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Thu, 09 Nov 2017 10:38:11 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440656#M34832 prma7799 2017-11-09T10:38:11Z Re: Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440657#M34833 <HTML><HEAD></HEAD><BODY><P>This is exctly what i suspect...</P></BODY></HTML> Thu, 09 Nov 2017 10:39:45 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440657#M34833 micheledenardi 2017-11-09T10:39:45Z Re: Sort pivot table measure https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440658#M34834 <HTML><HEAD></HEAD><BODY><P>That's I told you due to request number it is not giving proper sorting.</P></BODY></HTML> Thu, 09 Nov 2017 10:46:30 GMT https://community.qlik.com/t5/App-Development/Sort-pivot-table-measure/m-p/1440658#M34834 prma7799 2017-11-09T10:46:30Z