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

SilvioQlik — Fri, 08 Sep 2023 14:11:53 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

J_Lindberg — Mon, 11 Sep 2023 12:45:09 GMT

Hello @SilvioQlik , this forum is for the product "Qlik application automation" where we are able to help with questions related to this product. Please post this question in the forum related to the product you are using. Perhaps Qlik Sense: https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense

Or QlikView: https://community.qlik.com/t5/QlikView/ct-p/qlikview

topic Aggr(RangeSum(Above( .... Sorting Problem in Qlik Automate

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

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