Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Forecasting in QlikView

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?

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

Not applicable
Author

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