topic Re: Cumulative Sum in QlikView

Cumulative Sum

Wed, 30 Sep 2015 05:58:23 GMT

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

Basically I need the formula for Cumulative exit

thanks in advance

regards,

Lanie

jonathandienst — Wed, 30 Sep 2015 07:09:33 GMT

Load script or front end?

Wed, 30 Sep 2015 07:20:14 GMT

Hi Lanie,

PLease see attached.

Thanks,

Richard

Wed, 30 Sep 2015 08:08:00 GMT

hi richard,

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

thanks

Thu, 01 Oct 2015 01:59:06 GMT

load script please...

settu_periasamy — Thu, 01 Oct 2015 04:39:36 GMT

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

];