topic Re: Cumulative Calculations in QlikView Expression in QlikView

Cumulative Calculations in QlikView Expression

Max1984 — Sat, 16 Nov 2024 01:56:33 GMT

Hello everyone.

I am trying to get a table as in the figure:

The formula I am using for column "Saldo":

Aggr(RangeSum(Above(Sum([# Importo Fattura Iva]),0,RowNo())),[% Master Calendar Date Num])- Aggr(RangeSum(Above(Sum([# Importo Fattura Pagamenti]),0,RowNo())),[% Master Calendar Date Num])

I would like the column "Saldo" to give me a correct progressive rollup. Given that I have concatenated two different tables.

Re: Cumulative Calculations in QlikView Expression

Brett_Bleess — Tue, 19 Nov 2019 15:41:06 GMT

Maurizio, check out the following Design Blog post, hoping it may be of help to you on this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581

The only other one that may help is this one I think:

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

Hopefully this helps you move things forward.

Regards,
Brett

Re: Cumulative Calculations in QlikView Expression

Max1984 — Wed, 20 Nov 2019 12:02:57 GMT

Thanks but no link has solved my problem. I believe that accumulation with more dimensions is very difficult.

regards