Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

cumulative sum

Hi experts,

Can some one let me know the way to get the cumulative sum of certain column if values are sorted in a table?

Also This should be done in load script.

Thanks,

Saranga

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

Try to look on the rangesum..

like

=rangesum(cumval, peek(outputval)) as outputval;

View solution in original post

4 Replies
Not applicable
Author

Forgot to mention that I need to implement that in qlik sense load script

settu_periasamy
Master III
Master III

Try to look on the rangesum..

like

=rangesum(cumval, peek(outputval)) as outputval;

tresesco
MVP
MVP

Qlik sense script and qlikview script are same in nature/engine. So that is not that important if you forget. What you missed is a sample input and output expected against that.

Not applicable
Author

Hi Settu Periasamy,

Thank you  sir . It is working ....

Really appreciate your great support .

BR// Saranga