Skip to content
This repository has been archived by the owner on May 24, 2024. It is now read-only.

Some of the sheets are not avaliable #58

Open
wangzhaof opened this issue Aug 3, 2021 · 1 comment
Open

Some of the sheets are not avaliable #58

wangzhaof opened this issue Aug 3, 2021 · 1 comment

Comments

@wangzhaof
Copy link

Hi my friend
I've deployed the SSE on my Qlik Sense Server.However in the demo qvf,some of the sheets can display normally but some of the sheets are not avaliable.Here is the screenshot

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

Error Sheet screenshot
image

Message of the error sheet in the console
image

At the same time,you can see some of the sheet are normal in the following screenshot
Normal sheet
image

Formula in the normal sheet
R.ScriptEval('library("TTR");SMA(ts(q$AgeOfDeath), n=$(SMA_NUMBER_OF_PERIODS))',[Age of Death] as AgeOfDeath)

Could someone help me solve this issue?Sincerly thanks

@rvaheldendaten
Copy link

Changing it to

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

worked for me!

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants