topic How to sort by expression? in QlikView https://community.qlik.com/t5/QlikView/How-to-sort-by-expression/m-p/1219758#M390203 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table and will like to sort by the expression, for example my expression is a sum of records, so I will like to sort from higher to lower.</P><P></P><P>The sort by Y-value is not working.</P><P></P><P>Any idea?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155054_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 02 Mar 2017 16:19:09 GMT Anonymous 2017-03-02T16:19:09Z How to sort by expression? https://community.qlik.com/t5/QlikView/How-to-sort-by-expression/m-p/1219758#M390203 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table and will like to sort by the expression, for example my expression is a sum of records, so I will like to sort from higher to lower.</P><P></P><P>The sort by Y-value is not working.</P><P></P><P>Any idea?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155054_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 02 Mar 2017 16:19:09 GMT https://community.qlik.com/t5/QlikView/How-to-sort-by-expression/m-p/1219758#M390203 Anonymous 2017-03-02T16:19:09Z Re: How to sort by expression? https://community.qlik.com/t5/QlikView/How-to-sort-by-expression/m-p/1219759#M390204 <HTML><HEAD></HEAD><BODY><P>Check Expression and write </P><P>Sum(YourfieldName) </P><P>Then change that to Descending. LIke:<IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155050_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 02 Mar 2017 16:27:43 GMT https://community.qlik.com/t5/QlikView/How-to-sort-by-expression/m-p/1219759#M390204 vishsaggi 2017-03-02T16:27:43Z