Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

LTM Values in Diagram

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.

qlikviewdiagramm1.jpg

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

qlikviewdiagramm2.jpg

I have tried the following formulas:

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

and

accumulation 12 steps back:

qlikviewdiagramm3.jpg

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!

0 Replies