topic Sorting a table with an expression in QlikView https://community.qlik.com/t5/QlikView/Sorting-a-table-with-an-expression/m-p/146131#M24738 <HTML><HEAD></HEAD><BODY><P>Pivot table sorts by order of the dimensions. The closest to your requirement that I could get was adding calcualted dimension on the second place, right Commune, and sortin it by numeric descending:<BR /><STRONG>aggr(count(distinct if(FL_SLL_VALIDE_ENGIN=1,CLE_DEPART_ENGIN)),LIB_CENTRE_APPEL1_COMMUNE,LIB_CENTRE)<BR /></STRONG>You can hide it the same way as you did with another calculated dimension.<BR />Note, that partial sums in this case should be done by this new dimension.</P></BODY></HTML> Mon, 08 Jun 2009 23:55:36 GMT Anonymous 2009-06-08T23:55:36Z Sorting a table with an expression https://community.qlik.com/t5/QlikView/Sorting-a-table-with-an-expression/m-p/146130#M24737 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />I just don't understand how to proceed for a very simple sort in ina pivot table.<BR />A qvw is joined for explanation.<BR />Thanks a lot for your help.</P></BODY></HTML> Mon, 08 Jun 2009 14:31:32 GMT https://community.qlik.com/t5/QlikView/Sorting-a-table-with-an-expression/m-p/146130#M24737 oxiofrt 2009-06-08T14:31:32Z Sorting a table with an expression https://community.qlik.com/t5/QlikView/Sorting-a-table-with-an-expression/m-p/146131#M24738 <HTML><HEAD></HEAD><BODY><P>Pivot table sorts by order of the dimensions. The closest to your requirement that I could get was adding calcualted dimension on the second place, right Commune, and sortin it by numeric descending:<BR /><STRONG>aggr(count(distinct if(FL_SLL_VALIDE_ENGIN=1,CLE_DEPART_ENGIN)),LIB_CENTRE_APPEL1_COMMUNE,LIB_CENTRE)<BR /></STRONG>You can hide it the same way as you did with another calculated dimension.<BR />Note, that partial sums in this case should be done by this new dimension.</P></BODY></HTML> Mon, 08 Jun 2009 23:55:36 GMT https://community.qlik.com/t5/QlikView/Sorting-a-table-with-an-expression/m-p/146131#M24738 Anonymous 2009-06-08T23:55:36Z Sorting a table with an expression https://community.qlik.com/t5/QlikView/Sorting-a-table-with-an-expression/m-p/146132#M24739 <HTML><HEAD></HEAD><BODY><P>forgot the file...</P></BODY></HTML> Mon, 08 Jun 2009 23:57:52 GMT https://community.qlik.com/t5/QlikView/Sorting-a-table-with-an-expression/m-p/146132#M24739 Anonymous 2009-06-08T23:57:52Z