https://community.qlik.com/t5/App-Development/Aggr-Sorting-RowNo-Total/m-p/1793604#M62153 <P>Not working as expected as this will change my dimension order which I do not want.</P> Tue, 23 Mar 2021 08:23:58 GMT Rambo 2021-03-23T08:23:58Z https://community.qlik.com/t5/App-Development/Aggr-Sorting-RowNo-Total/m-p/1791532#M61904 <P>Hi Community,</P><P>I'm trying to sort an AGGR expression without success. Please see if you can help me out.</P><P>Would highly appreciate any alternate solutions too please (not from script please as I have some dynamic frontend calculations)!</P><P>Aggr(nodistinct RowNo(TOTAL),Name,(Id,(NUMERIC,ASCENDING)))</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Rambo_1-1615830060274.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/51184iB175CFF4958F7E33/image-size/medium?v=v2&amp;px=400" role="button" title="Rambo_1-1615830060274.png" alt="Rambo_1-1615830060274.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>Regards,</P><P>Rambo</P> Mon, 15 Mar 2021 17:46:24 GMT https://community.qlik.com/t5/App-Development/Aggr-Sorting-RowNo-Total/m-p/1791532#M61904 Rambo 2021-03-15T17:46:24Z https://community.qlik.com/t5/App-Development/Aggr-Sorting-RowNo-Total/m-p/1791536#M61905 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/137335">@Rambo</a>&nbsp;, did you try using the chart order ?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="QFabian_0-1615830899113.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/51185i9B06FA189F6B6D64/image-size/medium?v=v2&amp;px=400" role="button" title="QFabian_0-1615830899113.png" alt="QFabian_0-1615830899113.png" /></span></P><P>&nbsp;</P> Mon, 15 Mar 2021 17:54:31 GMT https://community.qlik.com/t5/App-Development/Aggr-Sorting-RowNo-Total/m-p/1791536#M61905 QFabian 2021-03-15T17:54:31Z https://community.qlik.com/t5/App-Development/Aggr-Sorting-RowNo-Total/m-p/1793600#M62151 <P>Instead of RowNo, go with rank function please.</P><DIV>num(rank(max("KPI Value"),4))</DIV> Tue, 23 Mar 2021 08:16:01 GMT https://community.qlik.com/t5/App-Development/Aggr-Sorting-RowNo-Total/m-p/1793600#M62151 brijesh1991 2021-03-23T08:16:01Z https://community.qlik.com/t5/App-Development/Aggr-Sorting-RowNo-Total/m-p/1793603#M62152 <P>Thank you; this works! Appreciated.</P> Tue, 23 Mar 2021 08:23:16 GMT https://community.qlik.com/t5/App-Development/Aggr-Sorting-RowNo-Total/m-p/1793603#M62152 Rambo 2021-03-23T08:23:16Z https://community.qlik.com/t5/App-Development/Aggr-Sorting-RowNo-Total/m-p/1793604#M62153 <P>Not working as expected as this will change my dimension order which I do not want.</P> Tue, 23 Mar 2021 08:23:58 GMT https://community.qlik.com/t5/App-Development/Aggr-Sorting-RowNo-Total/m-p/1793604#M62153 Rambo 2021-03-23T08:23:58Z https://community.qlik.com/t5/App-Development/Aggr-Sorting-RowNo-Total/m-p/2497683#M102769 <PRE class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Çeviri" data-ved="2ahUKEwjWq8uqp6KKAxXK3gIHHW_GIjQQ3ewLegQICRAU" aria-label="Çevrilmiş metin: Hello, How can I do the order in the attached picture?"><SPAN class="Y2IQFc">Hello,</SPAN></PRE> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Çeviri" data-ved="2ahUKEwjWq8uqp6KKAxXK3gIHHW_GIjQQ3ewLegQICRAU" aria-label="Çevrilmiş metin: How do I formulate the order I specified in the table below?"><SPAN class="Y2IQFc">How do I formulate the order I specified in the table below?</SPAN></PRE> <PRE class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Çeviri" data-ved="2ahUKEwjWq8uqp6KKAxXK3gIHHW_GIjQQ3ewLegQICRAU" aria-label="Çevrilmiş metin: Hello, How can I do the order in the attached picture?"><SPAN class="Y2IQFc"><BR /><BR /></SPAN></PRE> <TABLE width="389"> <TBODY> <TR> <TD width="134">COD</TD> <TD width="159">ID</TD> <TD width="96">ORDER</TD> </TR> <TR> <TD>234234</TD> <TD>ENGİN</TD> <TD>1</TD> </TR> <TR> <TD>23423</TD> <TD>ENGİN</TD> <TD>2</TD> </TR> <TR> <TD>4235</TD> <TD>MESUT&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>123412</TD> <TD>CENGİZ</TD> <TD>1</TD> </TR> <TR> <TD>1423</TD> <TD>SEDAT</TD> <TD>1</TD> </TR> <TR> <TD>436</TD> <TD>SEDAT</TD> <TD>2</TD> </TR> <TR> <TD>67</TD> <TD>SEDAT</TD> <TD>3</TD> </TR> <TR> <TD>56856</TD> <TD>NURETTİN</TD> <TD>1</TD> </TR> <TR> <TD>78</TD> <TD>HASAN</TD> <TD>1</TD> </TR> <TR> <TD>4563423</TD> <TD>SEBAHATTİN</TD> <TD>1</TD> </TR> <TR> <TD>235</TD> <TD>IŞIK GIDA</TD> <TD>1</TD> </TR> <TR> <TD>6546</TD> <TD>ABDULKADİR</TD> <TD>1</TD> </TR> <TR> <TD>578</TD> <TD>ABDULKADİR</TD> <TD>2</TD> </TR> <TR> <TD>578567434</TD> <TD>ABDULKADİR</TD> <TD>3</TD> </TR> <TR> <TD>34564</TD> <TD>ABDULKADİR</TD> <TD>4</TD> </TR> <TR> <TD>56879685</TD> <TD>ABDULKADİR</TD> <TD>5</TD> </TR> <TR> <TD>3546352</TD> <TD>ENGİN</TD> <TD>3</TD> </TR> <TR> <TD>567476</TD> <TD>ENGİN</TD> <TD>4</TD> </TR> <TR> <TD>967857</TD> <TD>ENGİN</TD> <TD>5</TD> </TR> <TR> <TD>568567</TD> <TD>NURETTİN</TD> <TD>2</TD> </TR> </TBODY> </TABLE> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Çeviri" data-ved="2ahUKEwjWq8uqp6KKAxXK3gIHHW_GIjQQ3ewLegQICRAU" aria-label="Çevrilmiş metin: Hello, How can I do the order in the attached picture?"><SPAN class="Y2IQFc"><BR /></SPAN></PRE> Thu, 12 Dec 2024 13:40:50 GMT https://community.qlik.com/t5/App-Development/Aggr-Sorting-RowNo-Total/m-p/2497683#M102769 tolgaclk 2024-12-12T13:40:50Z