topic Re: Not able to run Holt-Winters in Integration, Extension & APIs

Not able to run Holt-Winters

Anonymous — Sat, 16 Nov 2024 08:42:43 GMT

I downloaded the example app R_TimeSeriesAnalysis, however, I have not been able to run the script for the Holt-Winters method. I get the message: "Client Specified an Invalid Argument". I was able to run the example for moving averages but not this one. I also tried with a different dataset but it didn´t work.

The code, as included in the app is the following:

R.ScriptEval('library(TTR);library(forecast);forecast(HoltWinters(q$sumRain, beta=FALSE, gamma=FALSE), h=$(RainNumberOfYears))$fitted', Sum([rain]) as sumRain)

Has anyone experienced a similar issue?

What are the conditions that the data should meet?

Please help!

Re: Not able to run Holt-Winters

maura_baltazar — Thu, 15 Feb 2018 23:52:26 GMT

Hello, Try to change the R code

'Rainfall London Forecast' sheet:

'library("TTR"); library("forecast"); forecast:::forecast.HoltWinters(HoltWinters(q$sumRain, beta=FALSE, gamma=FALSE),h=8)$fitted'

'Annual rainfall London 1813-1912' sheet:

'library(TTR);library(forecast);data.frame(forecast(HoltWinters(q$sumRain, beta=FALSE, gamma=FALSE), h=$(RainNumberOfYears)))[,1]'

Hope that helps

Re: Not able to run Holt-Winters

Anonymous — Tue, 20 Feb 2018 21:25:45 GMT

Unfortunately, this didn´t work for me!

I am a little bit frustrated after trying to make this work.

Thanks in any case!

Aineth

2018-02-16 8:13 GMT-06:00 Maura Baltazar <qcwebmaster@qlikview.com>:

Re: Not able to run Holt-Winters

mjones87 — Tue, 17 Apr 2018 11:59:59 GMT

Hi Aineth,

Your R code looks the same as mine and mine is working ok.

Do the other visualisations in the qvf work ok?

Have you installed the requisite R packages (TTR, forecast)?

Re: Not able to run Holt-Winters

yannick_c — Tue, 17 Apr 2018 12:57:07 GMT

Hi,

You forgot 2 semicolons after the function forecast() and at the end of the script.

R.ScriptEval('library(TTR);library(forecast);forecast(HoltWinters(q$sumRain, beta=FALSE, gamma=FALSE)

; <--

h=$(RainNumberOfYears))$fitted

; <--

', Sum([rain]) as sumRain)

Re: Not able to run Holt-Winters

asiic999 — Thu, 23 Aug 2018 21:19:51 GMT

Hello, I also have that detail, but I found a possible solution, I do not know if it is the same result.

1.- update the version of R, the forecast library works from the version 3.5.1

2.- I guess this function has to predict, but as it is up to the same year known, I think it is not the original result

R.ScriptEval('library("TTR"); library("forecast"); HoltWinters(q$sumRain, beta=FALSE, gamma=FALSE)$fitted', Sum([rain]) as sumRain)

3.- The link shows how to use the predict functions using the same library
Método Holt-Winters para Predicciones en R