Sort result of AGGR() function

[Black_Hole]

Hello all,

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)

Please could you help me to understand the reason.

Thank you in advance for your help.

[sergio0592 · Accepted solution]

Hi,

Take a look here, it mights help you

https://community.qlik.com/t5/Qlik-Design-Blog/The-sortable-Aggr-function-is-finally-here/bc-p/14702...

[marcus_sommer]

The use of rowno() disabled the sorting.

- Marcus