Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

darrellbutler
Contributor

Rolling Twelve Months

Hi, I want to plot a graph with month year as a dimension. The expression I want to show is the last twelve months sales. So for Jan2011 I want to show sales from Feb 2010 to Jan 2011 and so on.

Any pointers gratefully received !

2 Replies
Not applicable

Rolling Twelve Months

Easiest way is to make it a calculated dimension

if(month_year>=time_period_begin and month_year<=time_period_end,month_year)

Then select

Supress when value is null

SunilChauhan
Esteemed Contributor

Re: Rolling Twelve Months

see the attached file

hope this helps