topic Re: R integration with Qlikview in QlikView

R integration with Qlikview

nakuldev — Fri, 25 May 2018 12:24:00 GMT

Hi All,

I got a requirement where I need to integrate R with QlikView. I wrote some basic macros to run R-code and failed.

On my desktop I have created a path for R which consists of 3 folders i.e, input, output and R-script file. Macro should run R code which will trigger the R-script in the specified path and executed file should get uploaded to the output folder. All this is happening manually now but we are trying to automate this process. Could some one suggest/help me with this requirement.

Thanks in Advance

Nakul

Re: R integration with Qlikview

petter — Fri, 25 May 2018 14:18:35 GMT

How did the basic macros fail? Could you share the code you wrote?

Re: R integration with Qlikview

petter — Fri, 25 May 2018 14:36:28 GMT

Have you tried something similar to this?

Notice that you have to select "Allow System Access" for the "Current Local Security" drop-down.

You should be able to replace the "excel.exe" with the R executable with path and parameters....