topic Cumulative delta in chart in QlikView

Cumulative delta in chart

claudio1 — Tue, 18 Oct 2011 16:53:35 GMT

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

Tue, 18 Oct 2011 20:05:25 GMT

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

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

claudio1 — Wed, 19 Oct 2011 08:45:26 GMT

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