topic Re: Forecasting in QlikView in QlikView

Forecasting in QlikView

Mon, 12 Jun 2017 11:15:54 GMT

I gone through the below thread to understand how forecasting is done in QlikView, but in my scenario I am confused to write the expression

Matching linest_m and linest_b function to auto-generated trendline

I am using line chart

Dimension:

MonthYear

Expression:

=avg(aggr(avg(Acuuracy),MonthYear,Supplier))

Above expression calculate % values

I have data from Jan-2016 to Jun-2017. Now I want to show trend for future months from Jul-2017 to Dec-2017

I have all values in MonthYear, but actual data is available from Jan-2016 to Jun-2017

How should I write the expression for this?

Re: Forecasting in QlikView

sunny_talwar — Mon, 12 Jun 2017 11:22:37 GMT

May be something like this

LINEST_M(Total Aggr(Avg(Aggr(Avg(Acuuracy), MonthYear, Supplier)), MonthYear), MonthYear)

LINEST_B(Total Aggr(Avg(Aggr(Avg(Acuuracy), MonthYear, Supplier)), MonthYear), MonthYear)

Re: Forecasting in QlikView

sunny_talwar — Mon, 12 Jun 2017 11:23:45 GMT

Or this for forecasting

LINEST_M(Total Aggr(Avg(Aggr(Avg(Acuuracy), MonthYear, Supplier)), MonthYear), MonthYear) * MonthYear + LINEST_B(Total Aggr(Avg(Aggr(Avg(Acuuracy), MonthYear, Supplier)), MonthYear), MonthYear)

Re: Forecasting in QlikView

Mon, 12 Jun 2017 11:42:39 GMT

Hi sunny,

Thanks for your reply

for Jan-2016 to Jun-2017, I need to show actual values while from Jul-2017 to Dec-2017 I need to display foretasted value

Re: Forecasting in QlikView

sunny_talwar — Mon, 12 Jun 2017 12:00:07 GMT

May be this

If(Avg(Aggr(Avg(Acuuracy), MonthYear, Supplier)) <> 0, Avg(Aggr(Avg(Acuuracy), MonthYear, Supplier)),

LINEST_M(Total Aggr(Avg(Aggr(Avg(Acuuracy), MonthYear, Supplier)), MonthYear), MonthYear) * MonthYear + LINEST_B(Total Aggr(Avg(Aggr(Avg(Acuuracy), MonthYear, Supplier)), MonthYear), MonthYear))