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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Forecast in QlikView

Hi Guys,

I am attempting to create a Sales Forecast using QlikView and basing forecast sales on the past 3 months actual sales.

i.e.

October Sales = 506

November Sales = 602

December Sales = 719

January should be = 609   (506+602+719) / 3

February should be = 643 (602+719+609) / 3

March should be = 657 (719+609+643) / 3

I would like to plot this in a QlikView chart.

Any ideas will be greatly appreciated.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

PFA


Red line - Forecast

Green line - Actual

aaa.png

View solution in original post

2 Replies
tresesco
MVP
MVP

PFA


Red line - Forecast

Green line - Actual

aaa.png

Not applicable
Author

Thank you.