Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Highlighted
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)

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