Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
roy_fredericks
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
tresesco
MVP
MVP

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

roy_fredericks
Contributor
Contributor
Author

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