topic Re: Qlik Sense - Forecasting with R in Integration, Extension & APIs

Qlik Sense - Forecasting with R

Anonymous — Sat, 16 Nov 2024 09:18:26 GMT

Hi All,

we would like to implement a line chart which shows a trend about actual data and also for the future it has to show forecasted values generated by R script ( for ex.: fit = nnetar(rev(q$close)); rev(data.frame(forecast(fit,h=$(Forecast_Days)))[,1]))

Can it be done in one chart ?

We only was able to do this in two, first had the actual data from the data model second had the forecasted values.

Regards,

Istvan

Re: Qlik Sense - Forecasting with R

lironbaram — Tue, 12 Sep 2017 16:36:00 GMT

it can be done ,

you'll need to create a extra values in your date field , and then

you can display both actual and forecast

Re: Qlik Sense - Forecasting with R

dberkesacn — Tue, 12 Sep 2017 17:22:40 GMT

Hi lironbaram,

like this:

JustForTest:

Load * Inline [

Year, Measure, YearForForcast

2010, 100, 2010

2010, 50, 2010

2011, 100, 2011

2011, 60, 2011

2012, 88, 2012

2012, 77, 2012

2013, 200, 2013

2013, 10, 2013

2014, 16, 2014

2014, 250, 2014

2015, 250, 2015

2015, 230, 2015

,, 2016

,, 2017

,, 2018

,, 2019

,, 2020

];

BTW we are using 17 Jun.

Regards,

Daniel

Re: Qlik Sense - Forecasting with R

lironbaram — Tue, 12 Sep 2017 19:15:05 GMT

yes

or you can create different table with prediction dates

and just call the field with the same name

when creating a report the values from the two tables will be combined

Re: Qlik Sense - Forecasting with R

Anonymous — Wed, 13 Sep 2017 09:46:06 GMT

Hi,

We tried it, but always put the forecasted data to the begining of the timeline, as the pictures shows:

Is it possible to put the two line one after the another?

Regards,

Istvan.

Re: Qlik Sense - Forecasting with R

lironbaram — Wed, 13 Sep 2017 12:39:37 GMT

can you share the app

Re: Qlik Sense - Forecasting with R

Anonymous — Wed, 13 Sep 2017 12:46:44 GMT

Hi,

Yes. We made some changes, but basically the problem is still the same.

Regards,

Istvan.

Re: Qlik Sense - Forecasting with R

lironbaram — Thu, 14 Sep 2017 11:12:47 GMT

if you change the number of periods you want to forecast

then it draws a line for future periods also

so what excatly is missing from your point of view

Re: Qlik Sense - Forecasting with R

Anonymous — Thu, 14 Sep 2017 12:59:34 GMT

Hi,

We want to place the actual data and forecasted data in one chart and in one line, but when we tried this, the forecasted data always placed in the beginning of the line chart, not the end of it e.g. 2018 since it is a forecast.

So we have this:

But we want like this:

We also tried to binding the actual data with the forecasted data within R script and used calculation condition for the coloring, but the order of the rows of the result wasn't correct.

Regards,

Istvan.

Re: Qlik Sense - Forecasting with R

danielrozental — Thu, 14 Sep 2017 14:38:04 GMT

Here's my take on this, add some empty lines in the response.

Sorry, not really an R programmer.

Re: Qlik Sense - Forecasting with R

Anonymous — Mon, 18 Sep 2017 10:00:48 GMT

Hi,

Thanks, It's worked and helped a lot!

Meanwhile we found another solution with Advanced Analytics Extensions, which you can find here:

GitHub - AnalyticsEarth/AAIExpressionBuilder: Qlik Sense Plugin to create native master items to perform advanced analyt…

GitHub - mhamano/advanced-analytics-toolbox: Qlik Sense extension which allows you to create charts to perform advanced …

Best Regards,

Istvan.