topic Re: SORT ORDER in QlikView https://community.qlik.com/t5/QlikView/SORT-ORDER/m-p/1426483#M429567 <HTML><HEAD></HEAD><BODY><P>Put sort by expression asecnding ?</P></BODY></HTML> Fri, 15 Sep 2017 17:43:31 GMT Chanty4u 2017-09-15T17:43:31Z SORT ORDER https://community.qlik.com/t5/QlikView/SORT-ORDER/m-p/1426481#M429565 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>I have following Pivot table in my QV doc</P><P><IMG alt="Screenshot_1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176801_Screenshot_1.png" style="height: auto;" /></P><P>I want to sort MAIN_CREDIOR_NAME in descending order. So I have sorted it with following expression</P><P>AGGR(SUM({&lt;YEAR={2017}&gt;}FIN_PRE),MAIN_CREDIOR_NAME,RM)</P><P>But it is not sorted in that order. Pls help</P></BODY></HTML> Fri, 15 Sep 2017 17:30:06 GMT https://community.qlik.com/t5/QlikView/SORT-ORDER/m-p/1426481#M429565 upaliwije 2017-09-15T17:30:06Z Re: SORT ORDER https://community.qlik.com/t5/QlikView/SORT-ORDER/m-p/1426482#M429566 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi Uplai, sort works based on field values, so If 'A' is higher than 'B', 'A' will be above 'B' in all RM.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">A workoround is using a calculated dimension with Dual to assing a different internal value to each combination:</P><P style="font-size: 13.3333px;">=Aggr(Dual(MAIN_CREDIOR_NAME, Rowno(TOTAL)), RM, <SPAN style="font-size: 13.3333px;">MAIN_CREDIOR_NAME</SPAN>)</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Note that using this, when user selects <SPAN style="font-size: 13.3333px;">MAIN_CREDIOR_NAME in table, it's also selecting the row value for <SPAN style="font-size: 13.3333px;">RM.</SPAN></SPAN></P></BODY></HTML> Fri, 15 Sep 2017 17:43:27 GMT https://community.qlik.com/t5/QlikView/SORT-ORDER/m-p/1426482#M429566 rubenmarin 2017-09-15T17:43:27Z Re: SORT ORDER https://community.qlik.com/t5/QlikView/SORT-ORDER/m-p/1426483#M429567 <HTML><HEAD></HEAD><BODY><P>Put sort by expression asecnding ?</P></BODY></HTML> Fri, 15 Sep 2017 17:43:31 GMT https://community.qlik.com/t5/QlikView/SORT-ORDER/m-p/1426483#M429567 Chanty4u 2017-09-15T17:43:31Z