topic Re: 12 rolling months dynamically in QlikView https://community.qlik.com/t5/QlikView/12-rolling-months-dynamically/m-p/358469#M133040 <HTML><HEAD></HEAD><BODY><P>Hello Chriss</P><P></P><P>You can use this function to achieve what you need:</P><P>=AddMonths(today(),-12) ---&gt;This will return 7/19/2011</P><P>You can also use a variable instead of today and with that you can create the rolling 12 month view<BR />Hope this helps</P><P></P><P></P><P>Pablo</P></BODY></HTML> Thu, 19 Jul 2012 13:49:19 GMT 2012-07-19T13:49:19Z 12 rolling months dynamically https://community.qlik.com/t5/QlikView/12-rolling-months-dynamically/m-p/358468#M133039 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>I would like to create a control, that should manage 12 rolling months.</P><P></P><P>I have a data of 2009,2010,2011,2012, now we are in July, by default it should display the July 2012 in reverse of 12 months and a arrow button should move one month forward and one arrow button for backward.</P><P></P><P>Can any one tell me how to achieve it, any working example will be appreciable.</P><P></P><P>Regards</P><P></P><P>Chriss </P></BODY></HTML> Thu, 19 Jul 2012 13:34:34 GMT https://community.qlik.com/t5/QlikView/12-rolling-months-dynamically/m-p/358468#M133039 2012-07-19T13:34:34Z Re: 12 rolling months dynamically https://community.qlik.com/t5/QlikView/12-rolling-months-dynamically/m-p/358469#M133040 <HTML><HEAD></HEAD><BODY><P>Hello Chriss</P><P></P><P>You can use this function to achieve what you need:</P><P>=AddMonths(today(),-12) ---&gt;This will return 7/19/2011</P><P>You can also use a variable instead of today and with that you can create the rolling 12 month view<BR />Hope this helps</P><P></P><P></P><P>Pablo</P></BODY></HTML> Thu, 19 Jul 2012 13:49:19 GMT https://community.qlik.com/t5/QlikView/12-rolling-months-dynamically/m-p/358469#M133040 2012-07-19T13:49:19Z