topic Re: Forecasting in Qlikview in QlikView

Forecasting in Qlikview

amilafdo — Tue, 15 Dec 2020 02:02:11 GMT

Hi,

I am having a problem with creating a forecast line chart for the next 5 years based on last year sales.

eg: Last year sales is 100 Mn and each year it should be increased by 1.5 (forecast 1st year 100* 1.5, forecast 2nd year 150*1.5).

the chart should be as below

Thanks

Amila

Re: Forecasting in Qlikview

settu_periasamy — Tue, 15 Dec 2020 14:08:39 GMT

Hi,

May be try to use the expression like

Above(sum(sales)*1.5)

Re: Forecasting in Qlikview

amilafdo — Tue, 15 Dec 2020 15:14:54 GMT

Hi Settu,

Thanks for your reply, I have tried this and only one year is showing. I need to show for next 5 years.

Thanks

Amila

Re: Forecasting in Qlikview

settu_periasamy — Wed, 16 Dec 2020 16:03:31 GMT

Do you have 5 years in your dimension or calendar table?

Re: Forecasting in Qlikview

amilafdo — Wed, 16 Dec 2020 17:38:07 GMT

Hi Settu,

I am having the last 2 years' data and no calendar data or dimensions for the future. I don't want to show the calendar year for the next 5 years and it is enough to show 1-5 in dimension (refer the image I shared).

Thanks

Amila