topic Calculation for Rolling Months? in QlikView https://community.qlik.com/t5/QlikView/Calculation-for-Rolling-Months/m-p/209044#M64189 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P>Anybody?? I thought someone among you might have already worked on this...</P></BODY></HTML> Mon, 11 Apr 2011 14:59:07 GMT 2011-04-11T14:59:07Z Calculation for Rolling Months? https://community.qlik.com/t5/QlikView/Calculation-for-Rolling-Months/m-p/209043#M64188 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P>I think its a basic query, but still tough as I am new to this. I have a chart which shows sales vs forecast for 52 weeks. However the requirement is this needs to be rolling 52 weeks, as in currently in week 10 for 2011, then the chart should show backwards till the week 11 for 2010, how can I achieve this?? Currently I have a Year Week field which has the format of 200901. How do I match it to say I want Current Week - 52 Weeks data at anytime?</P><P>Thanks Again</P></BODY></HTML> Mon, 11 Apr 2011 14:30:14 GMT https://community.qlik.com/t5/QlikView/Calculation-for-Rolling-Months/m-p/209043#M64188 2011-04-11T14:30:14Z Calculation for Rolling Months? https://community.qlik.com/t5/QlikView/Calculation-for-Rolling-Months/m-p/209044#M64189 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P>Anybody?? I thought someone among you might have already worked on this...</P></BODY></HTML> Mon, 11 Apr 2011 14:59:07 GMT https://community.qlik.com/t5/QlikView/Calculation-for-Rolling-Months/m-p/209044#M64189 2011-04-11T14:59:07Z