Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vinay_bangari
Valued Contributor III

how to display rolling 13 months in the line chart

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.

4 Replies
Employee
Employee

Re: how to display rolling 13 months in the line chart

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

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

MVP
MVP

Re: how to display rolling 13 months in the line chart

vinay_bangari
Valued Contributor III

Re: how to display rolling 13 months in the line chart

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

vinay_bangari
Valued Contributor III

Re: how to display rolling 13 months in the line chart

Hi Massimo,

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

Community Browser