Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
bartvanwetten
Creator
Creator

Cumulative Pivot Table

Hi all,

in the QlikView attachment there is a pivot table with a horizontal dimension. I would like to have the expression to be cumulative.

Can anybody help me out on this one?

Thx in advance!

Bart

3 Replies
sunny_talwar

I think before you might be able to do anything, you will need to populate the missing data..... what I mean is that all those places where you see white spaces, the combination doesn't exist in the database... you will need to create them and may be assign them a value of 0 for Bedrag.

Capture.PNG

sunny_talwar

See here on how you can generate missing data

Generating Missing Data In QlikView

zhadrakas
Specialist II
Specialist II

i think this would be the right Expression for your case:

=rangesum(sum(Bedrag),Before(TOTAL sum(Bedrag)),1,rowno(TOTAL))