Aggr() sorting of numerical field comes out in text order

[HenrikSievers]

I have a pivot table with 2 dimensions, market and production group.

For each combination I want to show how many customers make up 80% of sales in for that combination.

I am trying to follow the recipe for pareto analysis given by HiC Recipe for a Pareto Analysis – Revisited

However it does not work.

I have been able to locate the issue to the sorting in the aggr().

Using Concat to get the output of the Aggr:

Concat(
Aggr(
Sum([Forecast 2019-2020]),
([Forecast 2019-2020],(NUMERIC,REVERSE))
)
,'/')

But output seems to be sorted as text 

-0/-2144/-2764/-3937/-5/-5967/-824/0/0/0/10/100/100/1001/10014/1001728/1002/10025/1005/10066/1009/101/1011/1012/...

Any ideas how to fix this?

[edwin · Accepted solution]

it appears you are tricking the AGGR function into creating a table of your FORECAST fields.  so if i get it right, you just want a straight concat of your field ordered numericaly.  use concat ordering using weighted value:

concat([Forecast 2019-2020], '/', [Forecast 2019-2020])

where the last field is the ordering.  

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Strin...

i learned this from another post which i cant find rt now

[edwin]

found it.  it was Vegar that pointed it out:

https://community.qlik.com/t5/New-to-QlikView/Help-with-unique-records/m-p/1748654#M393321

[HenrikSievers]

Thanks.

Does it mean the concat function actually spoils the sorting of the aggr ?

Because I don't really need the concat, it is only a way to see the output of the aggr sorting.