Discussion board where members can get started with QlikView.
I am attempting to create a Sales Forecast using QlikView and basing forecast sales on the past 3 months actual sales.
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.
Red line - Forecast
Green line - Actual
View solution in original post