Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Thanks but no link has solved my problem. I believe that accumulation with more dimensions is very difficult.
regards