Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Cumulative Calculations in QlikView Expression

Hello everyone.

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

Image.jpg

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.

2 Replies
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Contributor III
Contributor III

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

regards