topic Re: R integration: time series forecast append in Integration, Extension & APIs

R integration: time series forecast append

Sat, 16 Nov 2024 09:23:14 GMT

Hi everyone,

I am trying to append a forecasted time series to a line chart of closing values for a stock. Qlik Sense gives me 'erroe: client specified an invalid argument'. I don't understand what I'm getting wrong. Many thanks for your help.

R.ScriptEval('library(forecast);data<-ts(na.omit(q$Variable1),frequency=1);fit<-auto.arima(data); res<-forecast(fit, level=0.95, h=q$vForecastPeriods); n <- length(q$Variable1); fore <- append(q$Variable1[(q$vForecastPeriods - 1):n],res$mean,after= n - q$vForecastPeriods); $fore;', Sum(Close) as Variable1, vForecastPeriods)

Re: R integration: time series forecast append

Anonymous — Tue, 22 Aug 2017 11:20:32 GMT

Hi Stan,

Currently, the R extension expects the same number of rows as a result. So you will need to add empty rows for the forecast values into the data that you send to R.

Regards,

Bas.

Re: R integration: time series forecast append

Tue, 22 Aug 2017 12:39:34 GMT

Hi Bas,

Thanks for the advice. I thought that's exactly what I'm doing above: sending in TS to R with its original length and retrieving TS - ForecastPeriods + Forecasts. Further thoughts are appreciated.

Re: R integration: time series forecast append

Anonymous — Wed, 23 Aug 2017 06:01:01 GMT

Hi Stan,

First, you're using a variable in your expression, you may want to try:

R.ScriptEval('library(forecast);'&

'data<-ts(na.omit(q$Variable1),frequency=1);'&

'fit<-auto.arima(data);'&

'res<-forecast(fit, level=0.95, h=q$vForecastPeriods); '&

'n <- length(q$Variable1); '&

'fore <- append(q$Variable1[(q$vForecastPeriods - 1):n],res$mean,after= n - q$vForecastPeriods); '&

'$fore;',

Sum(Close) as Variable1,

$(vForecastPeriods) as vForecastPeriods )

Second, to help you in troubleshooting check the logs for SSE2Rserve, this should give you an indication of what is wrong in the script.

Regards,

Bas

Re: R integration: time series forecast append

Wed, 23 Aug 2017 14:04:39 GMT

Hi Bas,

Many thanks. It was solved by

$(vForecastPeriods) as vForecastPeriods

However, I received error with $fore. I just took that $ out of your code and it worked like a charm.

Thanks again!

PS. Any ideas on how to integrate a fan chart are welcome.

Re: R integration: time series forecast append

yuankai0102 — Mon, 28 Aug 2017 08:59:43 GMT

Hi Stan,

Can i have your sample for this? im facing difficulties of mapping back the appended value back with dimension.

Thanks.

Re: R integration: time series forecast append

namrata_nm — Mon, 29 Apr 2019 11:12:48 GMT

Hi Bas,

I am a beginner in Qlik and R.

As you mentioned, that we need need to add empty rows for the forecast values that is sent to R, can you please let me know how can that be done ? And wont it hamper the other visualizations in Qlik ?

Thanks in Advance.

Regards,

Namrata

Re: R integration: time series forecast append

otwtm — Thu, 20 Aug 2020 10:03:24 GMT

I have a similar issue. The forecast period is plotted at the end of the data, but somewhere in the middle.