Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-04-06 04:28 AM

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

Labels (1)
Labels
934 Views
0 Likes
2 Replies
tresB
Champion III
Champion III
‎2018-04-06 04:57 AM

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

859 Views
0 Likes
Anonymous
Not applicable
‎2018-04-06 06:04 AM
Author

In response to tresB

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

test1.qvw
sample.xlsx
859 Views
0 Likes