Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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
Highlighted
MVP
MVP

Re: Forecast in QlikView

PFA


Red line - Forecast

Green line - Actual

aaa.png

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: Forecast in QlikView

PFA


Red line - Forecast

Green line - Actual

aaa.png

View solution in original post

Highlighted
Not applicable

Re: Forecast in QlikView

Thank you.