How to do Arima Forecasting of R ?

Anonymous · ‎2014-06-20

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

Report Inappropriate Content · ‎2014-06-20

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.

sujeetsingh · ‎2014-06-20

Even you can try a Text box in UI and then exporting it to PDF

Anonymous · ‎2014-06-20

Thanks for your reply.

But it will be great, if you can provide some code!! cause my above code is not working.

Thanks,

Prashant

Report Inappropriate Content · ‎2016-05-25

Please check this: