topic Re: cum sum from below in QlikView

cum sum from below

Anonymous — Wed, 09 Jul 2014 05:11:14 GMT

Hello!

Have some problem with calculation cumulative sum from below.

There is neccessary result in attached example

i calculate cumulative sum from top by:

rangesum(Above(sum(sales),0,rowno()))

but don't know how to calculate cum sum from below

Thanks for all advices!

Re: cum sum from below

tresB — Wed, 09 Jul 2014 05:17:35 GMT

Instead of Above() use it's counter part Below().

Use Above() with negetive offset. Like : =Above(Sum(Sales), -2,0)

Re: cum sum from below

its_anandrjs — Wed, 09 Jul 2014 05:25:49 GMT

Try with

From above

Rangesum(Above( Sum(sales) ),0, Rowno() )

and for Below or reverse accumulation

Rangesum(Below( Sum(sales) ),0, Rowno() )

Re: cum sum from below

jagan — Wed, 09 Jul 2014 06:09:28 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

Re: cum sum from below

Anonymous — Wed, 09 Jul 2014 06:35:44 GMT

is your example correct?

i need to show cum sum for each value from below.

In you file you calculate only total cum sum

Re: cum sum from below

Anonymous — Wed, 09 Jul 2014 06:39:02 GMT

and you calculate only two values every time- previous and next.. i think it's not cum sum

Re: Re: cum sum from below

Anonymous — Wed, 09 Jul 2014 06:55:14 GMT

it's working some strangely...

from value 1/5/2014 calculation is not correct !

Re: Re: cum sum from below

Anonymous — Wed, 09 Jul 2014 06:58:40 GMT

it's working some strangely...

from value 1/5/2014 calculation is not correct !

Re: Re: Re: cum sum from below

jagan — Wed, 09 Jul 2014 08:26:36 GMT

Hi,

Please find attached file for solution, wrong expression name in the set analysis earlier.

Regards,

Jagan.

Re: cum sum from below

Anonymous — Wed, 09 Jul 2014 09:20:38 GMT

it's what i need!

thank you!))