topic Re: Aggr with sort by expression in App Development

Aggr with sort by expression

julioarriaga — Sat, 16 Nov 2024 04:10:13 GMT

Hi, everyone,

I tried to sort an aggr by expression (just as it is used in a Pareto Analysis by Henric, https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis-Revisited/ba-p/1473684).

But it's not giving me the desired results, so I troubleshot my mistake with a simple example, and still it's not working.

The data is:

Test:
LOAD * INLINE [State,Amount
Ags,789
Jx,180
Mor,471
];

And the table is:

But it's not giving me desired descending order. I know in this example it's not necessary to use an aggr with expression sorting, but I need to get it right, so I can progress to my more complex real problem.

This can be solved by a "sort by" from the script, but in my real problem I don't have this option.

I add the qvf also.

As always, thank you for your help.

Re: Aggr with sort by expression

premvihari — Wed, 06 Nov 2019 04:13:20 GMT

Hi,

Please try bringing the Aggr expression field first in sorting order you will see the desired result.

Re: Aggr with sort by expression

julioarriaga — Wed, 06 Nov 2019 16:40:54 GMT

I already said in my post that this sorting is not an option, please, I'm not a newbie. The reason this is not an option is because I will be using inter record functions such as the 'Above' function.