topic Re: Graph rolling 24 months in QlikView

Graph rolling 24 months

vardhancse — Thu, 19 Nov 2015 09:25:09 GMT

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.

nagarjuna_kotha — Thu, 19 Nov 2015 09:37:58 GMT

Hi Sasi,

Try this Expression:

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

nagarjuna_kotha — Thu, 19 Nov 2015 09:45:35 GMT

PFA....

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

Regards,
Nagarjuna

neha_sri — Thu, 19 Nov 2015 09:52:52 GMT

Hi Sasi,

You can check here.

Regards,

Neha