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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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

Have you tried this?

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

View solution in original post

2 Replies
sunny_talwar

Have you tried this?

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

That's it!

 

Thank you very much 🙂