R - QlikView Integration

QlikView lacks of statistic tools to perform advanced analysis such as regression analysis, multivariate analysis, inference tests, predictive analytics, etc. There is a plug in which integrates QV and R. R is an open source programming tools for statistical computing and graphics (http://www.r-project.org). The integration is made through a COM interface. Three packages must be installed first previous to any analysis:

 1. statconnDCOM Server (http://rcom.univie.ac.at/download.html#statconnDCOM)

2. Rcom: is an R package allowing to have R and another program running at the same time and let them communicate.

 3. rscproxy is an R package which is required for Rcom and for the statconn (D)COM Server.

Once these three packages are installed, a VBS script can be used to call R and perform analysis. Open the macro edit module (CTRL+M) and make sure that “System Access” and “Allow System Access” are selected.

Finally, this is the vbs macro in QlikView. Click on the image to enlarge and see the content of the script.