Forecasting with time series data

[CHRIS_Singa]

Hey,

I might need your help.
I got time series data and would like to do a forecast without using the extension Advanced Qlik Analytics. How could I make it possible without the extension (using only script)? And if possible to plot it.

I really want to know the forecast for the next six months according my time series data.

Thank you

[Andrea_Spinetti]

Hello @CHRIS_Singa, if you are using Qlik Cloud I would suggest having a look here: Time series forecasting 😊

[CHRIS_Singa]

Hey Andrea_Spinetti,

I am not using the cloud version.

I am using Qlik Sense version that why I need help. 

[Andrea_Spinetti · Accepted solution]

@CHRIS_Singa at the moment, in QSEoW there is not a native way to perform forecasting. In any case, there are some tricks you can use to create a simple linear regression. One way is by extending the X-Axis directly in the Data Load Editor with the dates that you don’t have in the data model and then calculating the linear regression. I'll recommend you have look at the attached example created by one of our community members: