Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prachi_s_patkar
Contributor II
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.

Labels (1)
1 Reply
Anonymous
Not applicable

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