topic Re: How to sort on some expression in QlikView https://community.qlik.com/t5/QlikView/How-to-sort-on-some-expression/m-p/1140364#M917427 <HTML><HEAD></HEAD><BODY><P>You will need a custom sort expression for the dimensions if your table is a pivot (which it appears to be).</P><P></P><P>Your sample document is rather large, I suggest that you reduce it to make it easier to download and analyse.</P><P><A href="https://community.qlik.com/docs/DOC-1290">Preparing examples for Upload - Reduction and Data Scrambling</A></P></BODY></HTML> Fri, 13 May 2016 09:22:09 GMT jonathandienst 2016-05-13T09:22:09Z How to sort on some expression https://community.qlik.com/t5/QlikView/How-to-sort-on-some-expression/m-p/1140362#M917425 <HTML><HEAD></HEAD><BODY><P>How can I sort the below report regarding the expression ,</P><P>For eg,</P><P>My requirement is Highest variance will come first and then so on.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/124502_Capture.PNG" style="height: 357px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-sort-on-some-expression/m-p/1140362#M917425 suvechha_b 2020-11-25T16:16:04Z Re: How to sort on some expression https://community.qlik.com/t5/QlikView/How-to-sort-on-some-expression/m-p/1140363#M917426 <HTML><HEAD></HEAD><BODY><P>use</P><P>FirstStoredValue(Dim,-Value)</P></BODY></HTML> Fri, 13 May 2016 09:13:43 GMT https://community.qlik.com/t5/QlikView/How-to-sort-on-some-expression/m-p/1140363#M917426 Chanty4u 2016-05-13T09:13:43Z Re: How to sort on some expression https://community.qlik.com/t5/QlikView/How-to-sort-on-some-expression/m-p/1140364#M917427 <HTML><HEAD></HEAD><BODY><P>You will need a custom sort expression for the dimensions if your table is a pivot (which it appears to be).</P><P></P><P>Your sample document is rather large, I suggest that you reduce it to make it easier to download and analyse.</P><P><A href="https://community.qlik.com/docs/DOC-1290">Preparing examples for Upload - Reduction and Data Scrambling</A></P></BODY></HTML> Fri, 13 May 2016 09:22:09 GMT https://community.qlik.com/t5/QlikView/How-to-sort-on-some-expression/m-p/1140364#M917427 jonathandienst 2016-05-13T09:22:09Z Re: How to sort on some expression https://community.qlik.com/t5/QlikView/How-to-sort-on-some-expression/m-p/1140365#M917428 <HTML><HEAD></HEAD><BODY><P>May be look at this link:</P><P><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></BODY></HTML> Fri, 13 May 2016 09:27:58 GMT https://community.qlik.com/t5/QlikView/How-to-sort-on-some-expression/m-p/1140365#M917428 sunny_talwar 2016-05-13T09:27:58Z Re: How to sort on some expression https://community.qlik.com/t5/QlikView/How-to-sort-on-some-expression/m-p/1140366#M917429 <HTML><HEAD></HEAD><BODY><P>PFA.</P><P></P><P>Sample model attached.</P></BODY></HTML> Fri, 13 May 2016 09:28:49 GMT https://community.qlik.com/t5/QlikView/How-to-sort-on-some-expression/m-p/1140366#M917429 suvechha_b 2016-05-13T09:28:49Z