forecasting in qliksense

[manoj2102]

Hello,

I have a line chart with as dimension Year Month (ex . 201802) and in my expressions Count(Servers) as volume

Now for the volume I would like to make a Forecast (up to 6 months)

Can anyone help me with same.

[petter]

Maybe this could be of help for you:

Calculating trend lines, values and formulas on charts and tables in Qlik Sense

[petter]

Maybe a more advanced solution is what you need:

https://github.com/mhamano/advanced-analytics-toolbox

https://github.com/mhamano/advanced-analytics-toolbox/blob/master/docs/analysis/timeseries_forecast....

[manoj2102]

Hi Petter,

Thanks for response but this is giving me trendline only for monthyear for which Actuals(Count(Servers)) are present

I want that trend should show me values for next 6 month to forecast about future requirments of servers in next 6  months ie( from June 2018 to Dec 2018)

I want something similar to this

[petter]

You can use the LINEST function(s) in Qlik Sense to calculate a forecast. The LINEST is a linear regression function and I belive that it could be suitable for your case.

[petter]

If this answered your question please mark the appropriate answer as correct. If not please feel free to ask further questions to clarify...

[bhadraka1234]

Can you please guide on how to use this  extension, It says error occured when retrieving data from R

[cookiejest]

Hey we created a predictive line chart extension for qlik sense just for this use case. It can do things like linear, ARIMA and others. Dynamically of the data 🙂 Check it out.

https://blog.webofwork.com/predictive-line-chart-for-qlik-sense/

[GraceGao]

Hi Cookiejest

i have used below predictive line chart, everything is ok, However, i have published to the stream, and access denied when opening the sheet with predictive line chart. do you know how to fix it? Thanks.

[cookiejest]

Hey!

This is unlikely to do with the extension itself but rules engine security
on the extension?