LTM Values in Diagram

Mon, 11 Jul 2011 12:00:42 GMT

Hi,

I have period values for order intake, which I show as bars.

Additionally I would like to have a LTM (Last Twelve Months aka Rolling12) line in the diagram.

My problem is, if I have equal or less than 12 periods, it is more a YTD value, like he is simply adding up

the shown period values.

For example: Here he adds up the monthly values... I would like to let the line start already over the first value

with the last not visible 11 values + the period value visible.

If I have even less values, he simply adds them up, there is no Rolling 12:

I have tried the following formulas:

rangesum(above(sum(AE/1000),0,12))

and

accumulation 12 steps back:

As a LKM line/cuve is quite common, I hope someone has a solution??

Or do I somehow have to build a new value in the script somehow??

Thanks!

topic LTM Values in Diagram in QlikView