topic Aggr rangesum in QlikView

Aggr rangesum

AdamJaworski — Fri, 13 May 2022 21:02:17 GMT

Please help with the aggregation function. I need to add up the months for the year cumulatively.
Below is the effect I want to get.

Month	Year	Cost	Accumulate
01	2021	873 646,24 zł	873 646,24 zł
01	2022	975 894,97 zł	975 894,97 zł
02	2021	872 613,47 zł	1 746 259,71 zł
02	2022	1 127 169,20 zł	2 103 064,17 zł
03	2021	998 599,21 zł	2 744 858,92 zł
03	2022	1 443 874,39 zł	3 546 938,56 zł
04	2021	945 342,53 zł	3 690 201,45 zł
04	2022	982 992,69 zł	4 529 931,25 zł

Re: Aggr rangesum

Davis69 — Wed, 18 May 2022 03:38:18 GMT

@AdamJaworski wrote: Global Connect GM
Please help with the aggregation function. I need to add up the months for the year cumulatively.
Below is the effect I want to get.
Month Year Cost Accumulate

01 2021 873 646,24 zł 873 646,24 zł

01 2022 975 894,97 zł 975 894,97 zł

02 2021 872 613,47 zł 1 746 259,71 zł

02 2022 1 127 169,20 zł 2 103 064,17 zł

03 2021 998 599,21 zł 2 744 858,92 zł

03 2022 1 443 874,39 zł 3 546 938,56 zł

04 2021 945 342,53 zł 3 690 201,45 zł

04 2022 982 992,69 zł 4 529 931,25 zł
 

Aggr() returns an array of values for the expression calculated over the stated dimension or dimensions. For example, the maximum value of sales, per customer, per region. The Aggr function is used for nested aggregations, in which its first parameter (the inner aggregation) is calculated once per dimensional value.

Re: Aggr rangesum

AdamJaworski — Tue, 17 May 2022 06:47:53 GMT

what function should i use?

Re: Aggr rangesum

vinieme12 — Tue, 17 May 2022 07:16:50 GMT

=rangesum(Above(Sum(Cost),0,rowno(total)))

Refer these articles

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulative-Sums/ba-p/1468010

https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-oth...