Forecasting in QlikView

[#1]

Hi swuehl‌,

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?

[sunny_talwar]

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)

[sunny_talwar]

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)

[#4]

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

[sunny_talwar]

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))