Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
bartvanwetten
Contributor

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

Re: Cumulative Pivot Table

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

Re: Cumulative Pivot Table

See here on how you can generate missing data

Generating Missing Data In QlikView

zhadrakas
Valued Contributor

Re: Cumulative Pivot Table

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

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