Forecast trend lines

[Anonymous]

Hi

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 ?

Is this possible in native qlikview ?

Thanks

[tresesco]

Could you share a qvw with sample data set and explain the expected output?

[Anonymous]

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