Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Below is my code from which i am trying to read and do the forecast and then write that forecast into a file.
sub test
'create a COM object representing R
Set R = CreateObject("StatConnectorSrv.StatConnector")
R.Init "R"
'Pass data to R from csv
R.EvaluateNoReturn "setwd('C:\\R\\')"
R.EvaluateNoReturn "RSAS<-read.csv('RSAS.csv')"
R.EvaluateNoReturn "attach(RSAS)"
R.EvaluateNoReturn "'(R_fit <- auto.arima(RSAS$R))'"
R.EvaluateNoReturn "'(R_forecast <- forecast(R_fit, h=10))'"
R.EvaluateNoReturn "'(RMean<-R_forecast$mean)'"
R.EvaluateNoReturn "'(RMean1<-RMean$Point.Forecast)'"
R.EvaluateNoReturn "'(DisplayResult<-data.frame(RMean1))'"
R.EvaluateNoReturn "write.csv(DisplayResult,'Rmean2.csv')"
Thanks,
Prashant
I am also facing the same problem as above i.e.
How to do arima forecasting in qlikview???
Anybody knowing how to solve this than pl. reply ASAP.
Cheers Vijay
Qlikview Newbie.
Even you can try a Text box in UI and then exporting it to PDF
Thanks for your reply.
But it will be great, if you can provide some code!! cause my above code is not working.
Thanks,
Prashant
Please check this: