Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
MVP
MVP

Re: Forecast trend lines

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

Highlighted
Contributor
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