Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

andreyfcdk91
New Contributor III

cum sum from below

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!

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Re: Re: cum sum from below

Hi,

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

Regards,

Jagan.

9 Replies
MVP
MVP

Re: cum sum from below

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

Or

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

Re: cum sum from below

Try with

From above

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

and for Below or reverse accumulation

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

MVP
MVP

Re: cum sum from below

Hi,

Please find attached file for solution.

Regards,

Jagan.

andreyfcdk91
New Contributor III

Re: cum sum from below

is your example correct?

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

In you file you calculate only total cum sum

andreyfcdk91
New Contributor III

Re: cum sum from below

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

andreyfcdk91
New Contributor III

Re: Re: cum sum from below

it's working some strangely...

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

andreyfcdk91
New Contributor III

Re: Re: cum sum from below

it's working some strangely...

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

MVP
MVP

Re: Re: Re: cum sum from below

Hi,

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

Regards,

Jagan.

andreyfcdk91
New Contributor III

Re: cum sum from below

it's what i need!

thank you!))

Community Browser