Qlik sense forecasting functionality

prachi_s_patkar — Sat, 16 Nov 2024 08:28:19 GMT

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.

Re: Qlik sense forecasting functionality

Anonymous — Thu, 05 Apr 2018 13:56:12 GMT

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

topic Re: Qlik sense forecasting functionality in Integration, Extension & APIs

Qlik sense forecasting functionality

Re: Qlik sense forecasting functionality