Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
New Contributor

Forecast trend lines

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

2 Replies
Highlighted
MVP
MVP

Re: Forecast trend lines

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

Highlighted
New Contributor

Re: Forecast trend lines

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