topic Re: Aggr(RangeSum(Above( .... Sorting Problem in App Development

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

SilvioQlik — Mon, 11 Sep 2023 13:13:30 GMT

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

Re: Aggr(RangeSum(Above( .... Sorting Problem

Oleg_Troyansky — Mon, 11 Sep 2023 13:39:23 GMT

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,

Re: Aggr(RangeSum(Above( .... Sorting Problem

SilvioQlik — Tue, 12 Sep 2023 15:50:11 GMT

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

Re: Aggr(RangeSum(Above( .... Sorting Problem

QlikJeremy — Tue, 19 Nov 2024 13:12:22 GMT

Thank you, the (Data_MAD,(text, Ascending)) part helped me too to get the right order on my expression.