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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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