topic Rolling Twelve Months in QlikView https://community.qlik.com/t5/QlikView/Rolling-Twelve-Months/m-p/318988#M117589 <HTML><HEAD></HEAD><BODY><P> 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. </P><P></P><P>Any pointers gratefully received !</P></BODY></HTML> Mon, 14 Nov 2011 22:24:37 GMT darrellbutler 2011-11-14T22:24:37Z Rolling Twelve Months https://community.qlik.com/t5/QlikView/Rolling-Twelve-Months/m-p/318988#M117589 <HTML><HEAD></HEAD><BODY><P> 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. </P><P></P><P>Any pointers gratefully received !</P></BODY></HTML> Mon, 14 Nov 2011 22:24:37 GMT https://community.qlik.com/t5/QlikView/Rolling-Twelve-Months/m-p/318988#M117589 darrellbutler 2011-11-14T22:24:37Z Rolling Twelve Months https://community.qlik.com/t5/QlikView/Rolling-Twelve-Months/m-p/318989#M117590 <HTML><HEAD></HEAD><BODY><P>Easiest way is to make it a calculated dimension</P><P>if(month_year&gt;=time_period_begin and month_year&lt;=time_period_end,month_year)</P><P></P><P>Then select </P><P>Supress when value is null</P></BODY></HTML> Mon, 14 Nov 2011 23:52:42 GMT https://community.qlik.com/t5/QlikView/Rolling-Twelve-Months/m-p/318989#M117590 2011-11-14T23:52:42Z Re: Rolling Twelve Months https://community.qlik.com/t5/QlikView/Rolling-Twelve-Months/m-p/318990#M117591 <HTML><HEAD></HEAD><BODY><P>see the attached file </P><P></P><P>hope this helps</P></BODY></HTML> Tue, 15 Nov 2011 06:32:30 GMT https://community.qlik.com/t5/QlikView/Rolling-Twelve-Months/m-p/318990#M117591 SunilChauhan 2011-11-15T06:32:30Z