Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
ptl14624
Contributor III
Contributor III

Cumulative Values

Hi.

I want to sum the values in this dynamic table.

Meaning:

in 2019-Apr, i want to have the units of 2019-Apr, plus, all the units before 2019-Apr.

In 2019-Mai, i want to have the units of 2019-Mai, plus, all the units before 2019-Mai.

And so on...

clipboard_image_0.png

 

Any ideas?

 

Thanks

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

Have you tried this?

RangeSum(Before(Sum(Measure), 0, ColumnNo()))

View solution in original post

2 Replies
sunny_talwar
MVP
MVP

Have you tried this?

RangeSum(Before(Sum(Measure), 0, ColumnNo()))
ptl14624
Contributor III
Contributor III
Author

That's it!

 

Thank you very much 🙂