Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello Prachi,
You can use R plugin to forecast using Time Series analysis.
You can check this one also :