Aggr(RangeSum(Above( .... Sorting Problem

[SilvioQlik]

Good Moning Comunity, I'm Silvio From Italy 

I have this Table :

I'm using the following formula to reach a progressive sum of QTA_PLAN for each KCODE ordered in ascending order with respect to the Data_MAD.  But as You can see on the Table the sorting is not correct.... I also tried to create a "chiave" with the concatenated information.. but it doesn't work.

Aggr(RangeSum(Above(sum([QTA_PLAN]), 0, RowNo())),KCODE,Chiave)

Can anyone kindly give me some help?

Thanks in advance

regards

Silvio

[Oleg_Troyansky]

Hi Silvio,

The image is very small and blurry, but it looks to me like your chart is not sorted the same way you sorted your AGGR, hence the impression that the cumulative sum doesn't work.

Another idea to explore - in the AGGR() function, data is sorted based on the load order. In order to sort data in a particular order, like you need, you should use so called "structured arguments", like this:

Aggr(RangeSum(Above(sum([QTA_PLAN]), 0, RowNo())),

KCODE,

(Chiave, (TEXT, ASCENDING))

)

Or, perhaps you need to replace Chiave the Date field in your AGGR dimensions, to ensure that it's sorted chronologically?

Come to the Masters Summit for Qlik in Dublin this October, to learn advanced AGGR() and Set Analysis  - I'm covering all these questions there!

Cheers,

[SilvioQlik · Accepted solution]

Hi Oleg Thanks a lot for Your support !!!

I use this fromula and It's Work !!!

sum(Aggr(RangeSum(Above(sum(QTA PLAN,),0, RowNo())),
KCODE,
(Data_MAD,(text, Ascending))))

Thanks !!!

silvio