Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
MVP
MVP

Re: Cumulative Sum

Load script or front end?

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

Re: Cumulative Sum

Hi Lanie,

PLease see attached.

Thanks,

Capture.JPG

Richard

Not applicable

Re: Cumulative Sum

hi richard,

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

thanks

Not applicable

Re: Cumulative Sum

load script please...

Re: Cumulative Sum

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

    ];