Forecast in QlikView

[#1]

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.

[tresesco · Accepted solution]

PFA

Red line - Forecast

Green line - Actual

[#3]

Thank you.