Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Please try bringing the Aggr expression field first in sorting order you will see the desired result.
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.