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.
vardhancse
Valued Contributor II

Graph rolling 24 months

Hi Team,

Here is the set of data I have, can please let me know how to create rolling 24 months data in a chart.

For eg. , the dashboard have June 2015 data, then in the bar trend I need to see from the Jul -13 to Jun- 15.

3 Replies
nagarjuna_kotha
Valued Contributor II

Re: Graph rolling 24 months

Hi Sasi,

Try this Expression:

=sum({<Date = {">=$(=MonthStart(Max( DateField), -24))<=$(=MonthEnd(Max( DateField)))"},YearField=,MonthField=>}Sale)

Highlighted
nagarjuna_kotha
Valued Contributor II

Re: Graph rolling 24 months

PFA....

in that Appliccation If u select Year  and Month it will gives you 24 months data.

Regards,
Nagarjuna

neha_sri
Contributor II

Re: Graph rolling 24 months

Hi Sasi,

You can check here.

Rolling Month

Regards,

Neha

Community Browser