Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to do Arima Forecasting of R ?

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

4 Replies
Not applicable
Author

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
Master III
Master III

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

Anonymous
Not applicable
Author

Thanks for your reply.

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

Thanks,

Prashant

Not applicable
Author