Cumulative Calculations in QlikView Expression

[Max1984]

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.

[Brett_Bleess]

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

[Max1984]

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

regards