Cumulative delta in chart

[claudio1]

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

[#2 · Accepted solution]

Hi

Why you don't use simply a  full accumulation (property> expressions > accumulation panel) ?

or

rangesum(top(sum(Delta),1,RowNo()))

JJ

[claudio1]

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