Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
PFA
Red line - Forecast
Green line - Actual
Thank you.