topic Rolling Month in QlikView https://community.qlik.com/t5/QlikView/Rolling-Month/m-p/241131#M91582 <HTML><HEAD></HEAD><BODY><P>hi all....</P><P></P><P>I am new in qlikview...</P><P>So, please tell me how can I create Rolling Month 12 ???? For Sales????</P><P></P><P>please sort out my problem.</P><P></P><P>thanks in advance...</P><P></P><P></P></BODY></HTML> Mon, 07 Mar 2011 13:19:18 GMT 2011-03-07T13:19:18Z Rolling Month https://community.qlik.com/t5/QlikView/Rolling-Month/m-p/241131#M91582 <HTML><HEAD></HEAD><BODY><P>hi all....</P><P></P><P>I am new in qlikview...</P><P>So, please tell me how can I create Rolling Month 12 ???? For Sales????</P><P></P><P>please sort out my problem.</P><P></P><P>thanks in advance...</P><P></P><P></P></BODY></HTML> Mon, 07 Mar 2011 13:19:18 GMT https://community.qlik.com/t5/QlikView/Rolling-Month/m-p/241131#M91582 2011-03-07T13:19:18Z Rolling Month https://community.qlik.com/t5/QlikView/Rolling-Month/m-p/241132#M91583 <HTML><HEAD></HEAD><BODY><P>Please can you provide an example? It is difficult to comprehend like this...</P></BODY></HTML> Mon, 07 Mar 2011 15:06:52 GMT https://community.qlik.com/t5/QlikView/Rolling-Month/m-p/241132#M91583 IAMDV 2011-03-07T15:06:52Z Rolling Month https://community.qlik.com/t5/QlikView/Rolling-Month/m-p/241133#M91584 <HTML><HEAD></HEAD><BODY>Try this: Your calculated dimension: =MonthName(Date) Expression: =Sum({1 =$(#vRollingStart) } Sales) Where variable vRollingStart=monthstart(addmonths(max(Date),-11)) vRollingEnd=monthend(max(Date)) Regards, tresesco</BODY></HTML> Mon, 07 Mar 2011 17:25:03 GMT https://community.qlik.com/t5/QlikView/Rolling-Month/m-p/241133#M91584 tresB 2011-03-07T17:25:03Z Rolling Month https://community.qlik.com/t5/QlikView/Rolling-Month/m-p/241134#M91585 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>Do u have months in your file?</P></BODY></HTML> Mon, 07 Mar 2011 17:31:56 GMT https://community.qlik.com/t5/QlikView/Rolling-Month/m-p/241134#M91585 Anonymous 2011-03-07T17:31:56Z Re:Rolling Month https://community.qlik.com/t5/QlikView/Rolling-Month/m-p/241135#M91586 <HTML><HEAD></HEAD><BODY><P>hi Oscarashi..</P><P>yes I have month in my file ....</P><P></P><P>thanks for reply.</P><P></P><P>Regards,</P><P>Shekhar Munjal</P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Tue, 08 Mar 2011 05:19:22 GMT https://community.qlik.com/t5/QlikView/Rolling-Month/m-p/241135#M91586 2011-03-08T05:19:22Z