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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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