how to display rolling 13 months in the line chart - Qlik Community

Anonymous · ‎2015-05-22

If i have a date column and i have to show rolling 13 months in the line chart. here my question is how to limit to show for that 13 months.

Clever_Anjos · ‎2015-05-22

You can use an expression that returns only data from last 13 months

sum({<DateField={">=$(=date(addmonths(Max(DateField)),-13) <= >=$(=date(Max(DateField))"}>}Value)

maxgro · ‎2015-05-22

rolling n in different ways

Anonymous · ‎2015-05-22

i will try and get back to you. thanks for your quick respond .

Anonymous · ‎2015-05-22

Hi Massimo,

Thanks a lot for your help. Let me check and i will udpate this Discussion.