topic Re: Regarding Sort order in Pivot Table for TOTAL in QlikView https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749661#M1035020 <HTML><HEAD></HEAD><BODY><P>Dear Max Dreamer,</P><P></P><P>Thanks for your quick resolution. However can you please explain the expression posted above</P><P></P><P>Specially </P><P></P><P>count(TOTAL &lt;DISP_CATEGORY&gt; )</P><P></P><P>What is this ???</P><P></P><P>Sarfaraz</P><P></P><P><BR /> </P></BODY></HTML> Thu, 22 Jan 2015 12:52:22 GMT sarfaraz_sheikh 2015-01-22T12:52:22Z Regarding Sort order in Pivot Table for TOTAL https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749659#M1035018 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I want to sort the my data total wise in pivot table ........I tried but failed to do so .</P><P></P><P>Kindly suggest any clue/solution/trick...</P><P></P><P>My QVW is also attached here for your reference.</P><P></P><P>Sarfaraz</P></BODY></HTML> Thu, 22 Jan 2015 12:29:41 GMT https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749659#M1035018 sarfaraz_sheikh 2015-01-22T12:29:41Z Re: Regarding Sort order in Pivot Table for TOTAL https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749660#M1035019 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use Sort using Expression</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;">&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">DISP_CATEGORY</SPAN><SPAN style="font-size: 8pt;">&gt; {&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">SUB_VERTICAL_DESC</SPAN><SPAN style="font-size: 8pt;">={'AUTO'} &gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">SI_NO</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P><P></P><P>Please Find attachement</P><P></P><P>Regards</P></BODY></HTML> Thu, 22 Jan 2015 12:37:41 GMT https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749660#M1035019 PrashantSangle 2015-01-22T12:37:41Z Re: Regarding Sort order in Pivot Table for TOTAL https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749661#M1035020 <HTML><HEAD></HEAD><BODY><P>Dear Max Dreamer,</P><P></P><P>Thanks for your quick resolution. However can you please explain the expression posted above</P><P></P><P>Specially </P><P></P><P>count(TOTAL &lt;DISP_CATEGORY&gt; )</P><P></P><P>What is this ???</P><P></P><P>Sarfaraz</P><P></P><P><BR /> </P></BODY></HTML> Thu, 22 Jan 2015 12:52:22 GMT https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749661#M1035020 sarfaraz_sheikh 2015-01-22T12:52:22Z Re: Regarding Sort order in Pivot Table for TOTAL https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749662#M1035021 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is this work for you or not??</P><P></P><P>Since as you requested you want sort data total wise.</P><P>and in your pivot table you are calculating total on Disp_category</P><P></P><P>Therefore I added the above expression in sort tab under RCA flag</P><P></P><P>Regards</P></BODY></HTML> Thu, 22 Jan 2015 13:02:55 GMT https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749662#M1035021 PrashantSangle 2015-01-22T13:02:55Z Re: Regarding Sort order in Pivot Table for TOTAL https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749663#M1035022 <HTML><HEAD></HEAD><BODY><P>Dear Max,</P><P></P><P>The solution given by you working on the selection .......When i click on Approval Related Then the counts is coming in sorted order ....However once i release the selection from approval related ...then counts is not coming in sorted order ..</P><P></P><P>I want initially the count should be appear in sorted order. I dont want the data to be sorted on selection movement.</P><P></P><P>kindly help in this regards...</P><P></P><P>Sarfaraz </P></BODY></HTML> Thu, 22 Jan 2015 13:09:10 GMT https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749663#M1035022 sarfaraz_sheikh 2015-01-22T13:09:10Z Re: Regarding Sort order in Pivot Table for TOTAL https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749664#M1035023 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>Kindly help if know the solution.</P><P></P><P>Sarfaraz</P></BODY></HTML> Thu, 22 Jan 2015 14:55:46 GMT https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749664#M1035023 sarfaraz_sheikh 2015-01-22T14:55:46Z Re: Regarding Sort order in Pivot Table for TOTAL https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749665#M1035024 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>Kindly reply it is urgent..</P><P></P><P>Sarfaraz </P></BODY></HTML> Fri, 23 Jan 2015 09:29:37 GMT https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749665#M1035024 sarfaraz_sheikh 2015-01-23T09:29:37Z Re: Regarding Sort order in Pivot Table for TOTAL https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749666#M1035025 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Please check the below attachment.</P><P></P><P>Regards</P><P></P><P>Krishna</P></BODY></HTML> Fri, 23 Jan 2015 10:02:39 GMT https://community.qlik.com/t5/QlikView/Regarding-Sort-order-in-Pivot-Table-for-TOTAL/m-p/749666#M1035025 krishna20 2015-01-23T10:02:39Z