topic cumulative sum in QlikView

cumulative sum

Tue, 29 Sep 2015 02:52:47 GMT

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

Re: cumulative sum

Tue, 29 Sep 2015 02:57:14 GMT

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

Re: cumulative sum

settu_periasamy — Tue, 29 Sep 2015 05:05:53 GMT

Try to look on the rangesum..

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

Re: cumulative sum

tresB — Tue, 29 Sep 2015 05:07:01 GMT

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.

Re: cumulative sum

Tue, 29 Sep 2015 07:05:21 GMT

Hi Settu Periasamy,

Thank you sir . It is working ....

Really appreciate your great support .

BR// Saranga