Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem with my chart, i need to to calculate an expression as some sort of "cumulative delta", this is my situation :
Delta for each week
week1 : 0
week2 : 1
week3 : 5
week4 : 1
week5 : 10
What i need
week1 : 0
week2 : 1
week3 : 6
week4 : 7
week5 : 17
the expression i use to calculate my Delta is :
=((sum({< DAYOFWEEK= {'monday'} >} quantity)) - above(sum({< DAYOFWEEK= {'monday'} >} quantity)))
I try to calculate the "cumulative delta" (What i need) in this way, but it doesn't work :
=rangesum(above(sum([Delta]),0,rowno()))
Does anyone know how to do that?
Thank you very much in advance for your help.
Cheers,
Claudio
Hi
Why you don't use simply a full accumulation (property> expressions > accumulation panel) ?
or
rangesum(top(sum(Delta),1,RowNo()))
JJ
Hi
Why you don't use simply a full accumulation (property> expressions > accumulation panel) ?
or
rangesum(top(sum(Delta),1,RowNo()))
JJ
Hello Jean-Jacques,
I didn't use full accumulation because i didn't know there was such feature 😄
(It's the first time i have to deal with Qlikview charts to be honest).
This is great, and it works perfectly, thank you very much for showing me this simple solution 😉
Regards,
Claudio