Discussion Board for collaboration related to Creating Analytics for QlikView.
Have some problem with calculation cumulative sum from below.
There is neccessary result in attached example
i calculate cumulative sum from top by:
but don't know how to calculate cum sum from below
Thanks for all advices!
Go to Solution.
Please find attached file for solution, wrong expression name in the set analysis earlier.
Instead of Above() use it's counter part Below().
Use Above() with negetive offset. Like : =Above(Sum(Sales), -2,0)
Rangesum(Above( Sum(sales) ),0, Rowno() )
and for Below or reverse accumulation
Rangesum(Below( Sum(sales) ),0, Rowno() )
Please find attached file for solution.
is your example correct?
i need to show cum sum for each value from below.
In you file you calculate only total cum sum
and you calculate only two values every time- previous and next.. i think it's not cum sum
it's working some strangely...
from value 1/5/2014 calculation is not correct !
it's what i need!