topic Re: forecasting in qliksense in App Development

forecasting in qliksense

manoj2102 — Tue, 12 Jun 2018 11:53:43 GMT

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.

Re: forecasting in qliksense

petter — Tue, 12 Jun 2018 12:33:22 GMT

Maybe this could be of help for you:

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

Re: forecasting in qliksense

petter — Tue, 12 Jun 2018 12:41:35 GMT

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.md

Re: forecasting in qliksense

manoj2102 — Wed, 13 Jun 2018 06:05:19 GMT

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

Re: forecasting in qliksense

petter — Wed, 13 Jun 2018 06:44:45 GMT

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.

Re: forecasting in qliksense

petter — Mon, 16 Jul 2018 22:57:52 GMT

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

Re: forecasting in qliksense

bhadraka1234 — Fri, 21 Sep 2018 10:23:44 GMT

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

Re: forecasting in qliksense

cookiejest — Wed, 11 Sep 2019 03:55:25 GMT

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/

Re: forecasting in qliksense

GraceGao — Wed, 11 Sep 2019 06:07:15 GMT

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.

Re: forecasting in qliksense

cookiejest — Wed, 11 Sep 2019 06:28:28 GMT

Hey!

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

Re: forecasting in qliksense

PriyankaShivhare — Fri, 25 Oct 2019 05:26:42 GMT

Facing the same issue...by any chance did u resolve the problem?

Re: forecasting in qliksense

GraceGao — Wed, 30 Oct 2019 02:41:18 GMT

Not yet, extension author replied to check it out. i am waiting for reply.