Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Aggr with sort by expression

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:

LOAD * INLINE [State,Amount

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.

Labels (2)
2 Replies


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

Creator II
Creator II

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.