Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try to look on the rangesum..
like
=rangesum(cumval, peek(outputval)) as outputval;
Forgot to mention that I need to implement that in qlik sense load script
Try to look on the rangesum..
like
=rangesum(cumval, peek(outputval)) as outputval;
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.
Hi Settu Periasamy,
Thank you sir . It is working ....
Really appreciate your great support .
BR// Saranga