topic Rolling back 7 weeks From current Week and Rolling Forward 4 weeks? in QlikView https://community.qlik.com/t5/QlikView/Rolling-back-7-weeks-From-current-Week-and-Rolling-Forward-4/m-p/554099#M207041 <HTML><HEAD></HEAD><BODY><P>Hello , i want to calculate the Sales for the 7 weeks back from the curr week and also 4 weeks forwards including the curr week?</P><P>Dimension is week and i want to show sales&nbsp; and targets week wise such that if i select any week or by default the curr week then it must also gives me rolling back 7 week sales&nbsp; and targets and 4 weeks forward sales and target .</P><P>And in case of curr week i.e. latest week whose data is available then in that case i will show targets for Rolling 4 weeks and rolling back 7 weeks for sales and targets.</P></BODY></HTML> Mon, 23 Sep 2013 11:13:31 GMT lakhansajwan 2013-09-23T11:13:31Z Rolling back 7 weeks From current Week and Rolling Forward 4 weeks? https://community.qlik.com/t5/QlikView/Rolling-back-7-weeks-From-current-Week-and-Rolling-Forward-4/m-p/554099#M207041 <HTML><HEAD></HEAD><BODY><P>Hello , i want to calculate the Sales for the 7 weeks back from the curr week and also 4 weeks forwards including the curr week?</P><P>Dimension is week and i want to show sales&nbsp; and targets week wise such that if i select any week or by default the curr week then it must also gives me rolling back 7 week sales&nbsp; and targets and 4 weeks forward sales and target .</P><P>And in case of curr week i.e. latest week whose data is available then in that case i will show targets for Rolling 4 weeks and rolling back 7 weeks for sales and targets.</P></BODY></HTML> Mon, 23 Sep 2013 11:13:31 GMT https://community.qlik.com/t5/QlikView/Rolling-back-7-weeks-From-current-Week-and-Rolling-Forward-4/m-p/554099#M207041 lakhansajwan 2013-09-23T11:13:31Z