topic Sort by total? in QlikView https://community.qlik.com/t5/QlikView/Sort-by-total/m-p/1360597#M417074 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is there a way to sort by the total?</P><P></P><P>I have the following table</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/162070_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>However, as you can see the Total's column that was created in the Presentation's tab selecting the Show Partial Sums. I have tried with sort by Y value but is changing the sort of the months and it's not sorting by highest total to lowest total. Is there a way to do this?</P><P></P><P>The expression is count of ids, so it's not possible to do the sum there.</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 03 May 2017 17:06:38 GMT Anonymous 2017-05-03T17:06:38Z Sort by total? https://community.qlik.com/t5/QlikView/Sort-by-total/m-p/1360597#M417074 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is there a way to sort by the total?</P><P></P><P>I have the following table</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/162070_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>However, as you can see the Total's column that was created in the Presentation's tab selecting the Show Partial Sums. I have tried with sort by Y value but is changing the sort of the months and it's not sorting by highest total to lowest total. Is there a way to do this?</P><P></P><P>The expression is count of ids, so it's not possible to do the sum there.</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 03 May 2017 17:06:38 GMT https://community.qlik.com/t5/QlikView/Sort-by-total/m-p/1360597#M417074 Anonymous 2017-05-03T17:06:38Z Re: Sort by total? https://community.qlik.com/t5/QlikView/Sort-by-total/m-p/1360598#M417075 <HTML><HEAD></HEAD><BODY><P>Sort the first dimension (not month) by expression. Use the same expression formula that you use in your chart expression.</P></BODY></HTML> Wed, 03 May 2017 17:23:20 GMT https://community.qlik.com/t5/QlikView/Sort-by-total/m-p/1360598#M417075 Gysbert_Wassenaar 2017-05-03T17:23:20Z