topic Retain accumulation after selection in QlikView

Retain accumulation after selection

Wed, 14 Nov 2012 13:25:13 GMT

Hi Community,

I want to add a new column that Sums the last 4 weeks of Value2.

I used accumulate with 4 step back. But my problem is when I select few weeks Example ,week 5 to week 10, the Accumulated values changes.

Any other solution to do this?

Please see attached qvw to view my sample file.

Thanks in advance!

Ronald

swuehl — Wed, 14 Nov 2012 13:40:51 GMT

Try something like this (without using the accumulation option) as expression:

=aggr(rangesum(above(sum({1}Value2),0,4)),Week)

=aggr(rangesum(above(sum({<Week>} Value2),0,4)),Week)

edit:

Week field load order must be in chronological order to make this work correctly.