topic Re: Forecast trend lines in QlikView https://community.qlik.com/t5/QlikView/Forecast-trend-lines/m-p/68209#M11211 <HTML><HEAD></HEAD><BODY><P>Yes sure. Please find attached. So what I want to do is forecast the 'weeks_behind' based on an average of the last 3 weeks. Thanks</P></BODY></HTML> Fri, 06 Apr 2018 10:04:23 GMT Anonymous 2018-04-06T10:04:23Z Forecast trend lines https://community.qlik.com/t5/QlikView/Forecast-trend-lines/m-p/68207#M11209 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I'd like to know if it is possible to draw forecasted trend lines on a chart. For instance if I have project timeline with month on the x axis and weeks on the y axis. What I'd like to do is show a dashed trend line which is a prediction of where the project is based on the average of the last 3 months ? </P><P></P><P>Is this possible in native qlikview ?</P><P></P><P>Thanks </P></BODY></HTML> Fri, 06 Apr 2018 08:28:26 GMT https://community.qlik.com/t5/QlikView/Forecast-trend-lines/m-p/68207#M11209 Anonymous 2018-04-06T08:28:26Z Re: Forecast trend lines https://community.qlik.com/t5/QlikView/Forecast-trend-lines/m-p/68208#M11210 <HTML><HEAD></HEAD><BODY><P>Could you share a qvw with sample data set and explain the expected output?</P></BODY></HTML> Fri, 06 Apr 2018 08:57:34 GMT https://community.qlik.com/t5/QlikView/Forecast-trend-lines/m-p/68208#M11210 tresB 2018-04-06T08:57:34Z Re: Forecast trend lines https://community.qlik.com/t5/QlikView/Forecast-trend-lines/m-p/68209#M11211 <HTML><HEAD></HEAD><BODY><P>Yes sure. Please find attached. So what I want to do is forecast the 'weeks_behind' based on an average of the last 3 weeks. Thanks</P></BODY></HTML> Fri, 06 Apr 2018 10:04:23 GMT https://community.qlik.com/t5/QlikView/Forecast-trend-lines/m-p/68209#M11211 Anonymous 2018-04-06T10:04:23Z