topic Re: Sort issue in QlikView https://community.qlik.com/t5/QlikView/Sort-issue/m-p/1014369#M930210 <HTML><HEAD></HEAD><BODY><P>you could add a sorting expression in the sort tab...like </P><P>sum(TOTAL&lt;<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Name, Sub Name</SPAN>&gt;<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">total </SPAN>)</P></BODY></HTML> Thu, 17 Mar 2016 13:23:23 GMT avinashelite 2016-03-17T13:23:23Z Sort issue https://community.qlik.com/t5/QlikView/Sort-issue/m-p/1014366#M930207 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am uisng a pivot table and I am using 3 dimensions and one Sum total in the expression. </P><P></P><P>Name, Sub Name, Month &amp; Total. I have month as horizontal.</P><P></P><P>I am looking to list the highest total Name and then Sub name under that, at the moment, it only lists the sub name by highest total. I have selected Y-value on the Name dimension and still no luck.</P><P></P><P>Any suggestions?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sort-issue/m-p/1014366#M930207 knightwriter 2020-11-25T16:16:04Z Re: Sort issue https://community.qlik.com/t5/QlikView/Sort-issue/m-p/1014367#M930208 <HTML><HEAD></HEAD><BODY><P>can u share sample qvw?</P><P>or screen sht hw it luks?</P></BODY></HTML> Thu, 17 Mar 2016 10:27:50 GMT https://community.qlik.com/t5/QlikView/Sort-issue/m-p/1014367#M930208 Chanty4u 2016-03-17T10:27:50Z Re: Sort issue https://community.qlik.com/t5/QlikView/Sort-issue/m-p/1014368#M930209 <HTML><HEAD></HEAD><BODY><P>Have a look here: <A href="https://community.qlik.com/docs/DOC-7220">Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)</A></P><P></P><P>- Marcus</P></BODY></HTML> Thu, 17 Mar 2016 10:39:17 GMT https://community.qlik.com/t5/QlikView/Sort-issue/m-p/1014368#M930209 marcus_sommer 2016-03-17T10:39:17Z Re: Sort issue https://community.qlik.com/t5/QlikView/Sort-issue/m-p/1014369#M930210 <HTML><HEAD></HEAD><BODY><P>you could add a sorting expression in the sort tab...like </P><P>sum(TOTAL&lt;<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Name, Sub Name</SPAN>&gt;<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">total </SPAN>)</P></BODY></HTML> Thu, 17 Mar 2016 13:23:23 GMT https://community.qlik.com/t5/QlikView/Sort-issue/m-p/1014369#M930210 avinashelite 2016-03-17T13:23:23Z Re: Sort issue https://community.qlik.com/t5/QlikView/Sort-issue/m-p/1014370#M930211 <HTML><HEAD></HEAD><BODY><P>Hi Avinash,</P><P></P><P>This partially works but ranks from lowest to highest, how do I flip it? </P></BODY></HTML> Thu, 17 Mar 2016 14:37:10 GMT https://community.qlik.com/t5/QlikView/Sort-issue/m-p/1014370#M930211 knightwriter 2016-03-17T14:37:10Z Re: Sort issue https://community.qlik.com/t5/QlikView/Sort-issue/m-p/1014371#M930212 <HTML><HEAD></HEAD><BODY><P>sorry, got it by changing to descending !</P></BODY></HTML> Thu, 17 Mar 2016 14:41:37 GMT https://community.qlik.com/t5/QlikView/Sort-issue/m-p/1014371#M930212 knightwriter 2016-03-17T14:41:37Z