topic Re: How to do Arima Forecasting of R ? in QlikView

How to do Arima Forecasting of R ?

Anonymous — Mon, 26 Jan 2026 16:26:21 GMT

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

Fri, 20 Jun 2014 06:42:25 GMT

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 — Fri, 20 Jun 2014 06:46:11 GMT

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

Anonymous — Fri, 20 Jun 2014 06:58:22 GMT

Thanks for your reply.

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

Thanks,

Prashant

Wed, 25 May 2016 10:48:58 GMT

Please check this: