I am currently facing some challenges while creating a connection between QV and R.
Some background info, I'm rather new in QlikView and I have only basic knowledge in R.
I found some examples here on how to create the connection between both tools, and which is also working.
However when I create a new application, just a simple one, it doesn't work like it supposed to. I believe the command 'R.EvaluateNoReturn' doesn't react.. Below you can find my code in a function that is triggered after clicking on a button.
As expected, the screen of statConn is shown after triggering the macro script.
|Set v = ActiveDocument.GetVariable("vAppPath")|
|CurrentPath = Replace(v.GetContent.String,"\","/")|
|'Export the selected data to R|
|Set MyData = ActiveDocument.GetSheetObject("DataToR")|
|'Create a COM object representing R|
|Set R = createobject("StatConnectorSrv.StatConnector")|
|R.EvaluateNoReturn "QVData <- c(1,2,3,4)"|
|R.EvaluateNoReturn "write.table(QVData,'text.txt',col.names = NA)"|
|'End connection with R|
It should generate a new txt-file with just 1,2,3,4 in it, but it doesn't work.
Has anyone suggestions? Are there alternatives of using 'EvaluateNoReturn'?
Thank you in advance!