https://community.qlik.com/t5/QlikView/Sort-result-of-AGGR-function/m-p/1754347#M453715 <P>Hello all,</P><P>I am trying to calculate the row no with the expression below, but I don't understand why the value displayed is not correctly sorted (i.e. by date)</P><P>Please could you help me to understand the reason.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Tab.PNG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/42696iCCAC919116B43EE5/image-size/medium?v=v2&amp;px=400" role="button" title="Tab.PNG" alt="Tab.PNG" /></span></P><P>&nbsp;</P><P>Thank you in advance for your help.</P><P>&nbsp;</P> Wed, 21 Oct 2020 07:14:01 GMT Black_Hole 2020-10-21T07:14:01Z https://community.qlik.com/t5/QlikView/Sort-result-of-AGGR-function/m-p/1754347#M453715 <P>Hello all,</P><P>I am trying to calculate the row no with the expression below, but I don't understand why the value displayed is not correctly sorted (i.e. by date)</P><P>Please could you help me to understand the reason.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Tab.PNG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/42696iCCAC919116B43EE5/image-size/medium?v=v2&amp;px=400" role="button" title="Tab.PNG" alt="Tab.PNG" /></span></P><P>&nbsp;</P><P>Thank you in advance for your help.</P><P>&nbsp;</P> Wed, 21 Oct 2020 07:14:01 GMT https://community.qlik.com/t5/QlikView/Sort-result-of-AGGR-function/m-p/1754347#M453715 Black_Hole 2020-10-21T07:14:01Z https://community.qlik.com/t5/QlikView/Sort-result-of-AGGR-function/m-p/1754667#M453724 <P>Hi,</P><P>Take a look here, it mights help you</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-sortable-Aggr-function-is-finally-here/bc-p/1470269" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-sortable-Aggr-function-is-finally-here/bc-p/1470269</A></P><P>&nbsp;</P> Wed, 21 Oct 2020 18:49:48 GMT https://community.qlik.com/t5/QlikView/Sort-result-of-AGGR-function/m-p/1754667#M453724 sergio0592 2020-10-21T18:49:48Z https://community.qlik.com/t5/QlikView/Sort-result-of-AGGR-function/m-p/1754867#M453731 <P>The use of rowno() disabled the sorting.</P><P>- Marcus</P> Thu, 22 Oct 2020 10:09:15 GMT https://community.qlik.com/t5/QlikView/Sort-result-of-AGGR-function/m-p/1754867#M453731 marcus_sommer 2020-10-22T10:09:15Z