Qlik Community

Qlik Server Side Extensions Discussions

Discussion Board for collaboration on Server-Side Extensions and Advanced Analytics Integration.

New Contributor II

Qlik sense forecasting functionality

Hi All ,

     We are in process to add forecasting functionality in Qlik Sense. We tried linear forecast by equation y=mx+b using Linest_M and

Linest_B function as below:

if(only({1}$(vPeriod))<=$(vLastMonthInt),null,linest_m(total aggr(if($(vPeriod)<=$(vLastMonthInt),$(vMeasure)),$(vPeriod)),$(vPeriod))*only({1}$(vPeriod))+linest_b(total aggr(if($(vPeriod)<=$(vLastMonthInt),$(vMeasure)),$(vPeriod)),$(vPeriod)))';

Above formula gives us only trend or linear forecast.

But our requirement is now to plot a reports, which uses Exponential smoothing kind of method for forecasting reports with seasonality and data fluctuations as per historical data.

Is there any forecasting functions available in Qlik other than Linest_M and Linest_B.  Or any other way to plot this kind of forecast reports in Qlik Sense.

Any help would be appreciated.

1 Reply
Contributor II

Re: Qlik sense forecasting functionality

Hello Prachi,

You can use R plugin to forecast using Time Series analysis.

You can check this one also :

AAI With R - Learning Exercises.pdf