topic Past 4 weeks' Averages and Forecasting next week in QlikView https://community.qlik.com/t5/QlikView/Past-4-weeks-Averages-and-Forecasting-next-week/m-p/504694#M188631 <HTML><HEAD></HEAD><BODY><P>Greetings,</P><P></P><P>I need your help on a project where I could not figure out calculating past 4 weeks' averages and forecasting next week.</P><P></P><P>I am trying to forecast next week's figure by reviewing past 30 days' figures. I would like to do this by week breakdown.</P><P>Today is 20 August 2013 and it is presently week 33 of the year. (2013/33). Here is what I would like to do:</P><P></P><P style="padding-left: 30px;">1 - I want to take average of weeks (2013/29-32) and then average its result with week 2013/33.</P><P style="padding-left: 30px;">2 - I have to show this final result at an additional column as I will assume that it will be forecasted cost to me for the present week.</P><P style="padding-left: 30px;">3 - I will always review -30 days from today in week breakdown to forecast week ahead.</P><P style="padding-left: 30px;">4 - I have to stick to product breakdown.</P><P></P><P>I can put this together in a pivot table but then I cannot apply my desired column that calculates the forecast. I tried set analysis as well but guess I am missing something.</P><P></P><P>Attached, you will find an excel table with 2 sheets. 1st sheet will be the data, 2nd sheet is illustrating what I am trying to achieve with QlikView. For your convenience, I used inline in the QlikView document for easy reloading.</P><P></P><P>Looking forward to your help and advice.</P><P>Best regards,</P><P></P><P>p1907</P></BODY></HTML> Tue, 20 Aug 2013 09:36:27 GMT 2013-08-20T09:36:27Z Past 4 weeks' Averages and Forecasting next week https://community.qlik.com/t5/QlikView/Past-4-weeks-Averages-and-Forecasting-next-week/m-p/504694#M188631 <HTML><HEAD></HEAD><BODY><P>Greetings,</P><P></P><P>I need your help on a project where I could not figure out calculating past 4 weeks' averages and forecasting next week.</P><P></P><P>I am trying to forecast next week's figure by reviewing past 30 days' figures. I would like to do this by week breakdown.</P><P>Today is 20 August 2013 and it is presently week 33 of the year. (2013/33). Here is what I would like to do:</P><P></P><P style="padding-left: 30px;">1 - I want to take average of weeks (2013/29-32) and then average its result with week 2013/33.</P><P style="padding-left: 30px;">2 - I have to show this final result at an additional column as I will assume that it will be forecasted cost to me for the present week.</P><P style="padding-left: 30px;">3 - I will always review -30 days from today in week breakdown to forecast week ahead.</P><P style="padding-left: 30px;">4 - I have to stick to product breakdown.</P><P></P><P>I can put this together in a pivot table but then I cannot apply my desired column that calculates the forecast. I tried set analysis as well but guess I am missing something.</P><P></P><P>Attached, you will find an excel table with 2 sheets. 1st sheet will be the data, 2nd sheet is illustrating what I am trying to achieve with QlikView. For your convenience, I used inline in the QlikView document for easy reloading.</P><P></P><P>Looking forward to your help and advice.</P><P>Best regards,</P><P></P><P>p1907</P></BODY></HTML> Tue, 20 Aug 2013 09:36:27 GMT https://community.qlik.com/t5/QlikView/Past-4-weeks-Averages-and-Forecasting-next-week/m-p/504694#M188631 2013-08-20T09:36:27Z