Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I was wondering if there is any function in QlikView which can predict, what data will be in the future in relation of data pattern?
I have already google it, but I didn't find anything useful. Maybe I wasn't looking with correct string.
Thank you,
Luka S.
Any Luck guys ???
Hi, Do you know the integration of R with qlikview. If yes then i am trying the below macro code and doing the prediction part using R. Please help me in the below code:
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 "RSAS1<-read.csv('RSAS.csv')"
R.EvaluateNoReturn "attach(RSAS1)"
R.EvaluateNoReturn "R_fit <- arima(RSAS1$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))'"
RResult=R.GetSymbol("DisplayResult")
msgbox(DisplayResult)
R.EvaluateNoReturn "write.csv(DisplayResult,'Rmean2.csv')"
'Close R connection
R.close
end sub
Hi Prashant,
If you haven't already solved your issue, I would first run each line of the code within R (or R studio if you prefer) to see if the code is failing which you won't be able to know when running the macro inside QV.
I found it was usually something to do with the working directory not set correctly.
Cheers,
TG
Thanks Thomas,
But I have resolved my issue.
Regards,
Prashant
thanks deepak it was very helpfull.
can we do the same in Qlik Sense