topic Rangesum issues. in QlikView

Rangesum issues.

Mon, 05 Mar 2012 19:58:04 GMT

Anyone know what I am doing wrong here? I am trying to get a rolling 12 month sum, but seems to be just taking the previous months total and adding 12 to it?!?

RangeSum(Below(sum([Sales Revenue])),0,12)

I thought the 0,12 section was telling it to go 12 months back and include the current month. (IE 11-2012 to 10-2011)

What am I doing wrong? I can not use the accumulate 12 steps back because I need to use this expression in another expression and also uses a rangeavg.

Rangesum issues.

swuehl — Mon, 05 Mar 2012 20:06:05 GMT

I believe you need to add the 0,12 section as arguments to the below function, not to the rangesum, to achieve what you want, so just move one closing bracket:

RangeSum(Below(sum([Sales Revenue]),0,12))

Rangesum issues.

Mon, 05 Mar 2012 20:33:01 GMT

Well that was it, I feel like an idiot now.

Thank you for your help as always.