topic Creating dummy dates in date field in QlikView https://community.qlik.com/t5/QlikView/Creating-dummy-dates-in-date-field/m-p/42238#M7122 <HTML><HEAD></HEAD><BODY><P>I have a set of dates and a value against these. What i want to do is create a forecasted trend lines for the weeks ahead based on an average of the last 3 weeks. </P><P></P><P>Please see data attached. The dates in red are the dates I want to generate and the value for these will be an average of the last 3 values. So the forecasted scroe for row 18 should be an average of 5.6 + 5.9 + 5.9.</P><P></P><P>Thank you</P></BODY></HTML> Mon, 16 Apr 2018 13:44:31 GMT Anonymous 2018-04-16T13:44:31Z Creating dummy dates in date field https://community.qlik.com/t5/QlikView/Creating-dummy-dates-in-date-field/m-p/42238#M7122 <HTML><HEAD></HEAD><BODY><P>I have a set of dates and a value against these. What i want to do is create a forecasted trend lines for the weeks ahead based on an average of the last 3 weeks. </P><P></P><P>Please see data attached. The dates in red are the dates I want to generate and the value for these will be an average of the last 3 values. So the forecasted scroe for row 18 should be an average of 5.6 + 5.9 + 5.9.</P><P></P><P>Thank you</P></BODY></HTML> Mon, 16 Apr 2018 13:44:31 GMT https://community.qlik.com/t5/QlikView/Creating-dummy-dates-in-date-field/m-p/42238#M7122 Anonymous 2018-04-16T13:44:31Z