topic Re: Accumulated sum based on dimension in QlikView

Accumulated sum based on dimension

fanninam — Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to get the accumulated aggregate sum per each FiscalMonthYr but instead I am getting the aggregate sum in total. How can I write the syntax so that it gives me the accumulated sum per each FiscalMonthYr instead of the total accumulated sum for all FiscalMonthYr combined?

I'm using this formula:

=AGGR(RangeSum(Sum({$<InvoiceType={'903','900'}>}TOTAL TransactionAmount)*-1),FiscalMonthYr)

Re: Accumulated sum based on dimension

Saravanan_Desingh — Thu, 23 Apr 2020 20:37:46 GMT

Can you please post some sample data and expected output?

Re: Accumulated sum based on dimension

Brett_Bleess — Wed, 20 May 2020 14:42:54 GMT

The following Design Blog post may be of some assistance on this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett