topic Accumulation behaviour - set a max accumulation date in QlikView

Accumulation behaviour - set a max accumulation date

Tue, 30 Mar 2010 02:45:48 GMT

Hi All,

I wish to accumulate an actual spend amount over a date period in a line graph.

The problem is that the line extends to the maximum date (horizontally). I want the line to stop at the maximum actual spend date, not the maximum date on my date calendar.

See below:-

So here, the blue line (Actual) will stop at Mar 2010.

How is this possible?

Thanks!

Accumulation behaviour - set a max accumulation date

deepakk — Tue, 30 Mar 2010 07:09:00 GMT

If possible can you attach a sample application

Accumulation behaviour - set a max accumulation date

Tue, 30 Mar 2010 13:33:35 GMT

I have done it like this

sum

(if(month(Budget_date) = month(Actual_date) and year(Budget_date) = year(Actual_date),Actual_value))

It works for me.

Anders