Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative Sum

Hi Need help for the formula to get the following results (last column should be cumulative sum of the 2nd column)

JML MonthExitsCumulative Exit
2015/05/3111
2015/06/3023
2015/08/3169
2015/09/3058

67

Basically I need the formula for Cumulative exit

thanks in advance

regards,

Lanie

5 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Load script or front end?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Hi Lanie,

PLease see attached.

Thanks,

Capture.JPG

Richard

Not applicable
Author

hi richard,

I would like to do this as a script rather ...

thanks

Not applicable
Author

load script please...

settu_periasamy
Master III
Master III

Try this

Cum:

Load [JML Month], Exits, RangeSum(Exits,Peek(Cumulative_Exit)) as Cumulative_Exit;

LOAD * INLINE [

     JML Month, Exits

    2015/05/31, 1

    2015/06/30, 2

    2015/08/31, 6

    2015/09/30, 58

    ];