Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
am new to qlikview so please help,
i would like 2 integrate the outputs of 'R' in my qlikview dashboards. i have find some solutions and it asked me to install 'R'
from The R Project for Statistical Computing which i have done,
then they asked 2 install 'DOWNLOAD STATCONNDCOM HOME&STUDENT' from 'http://rcom.univie.ac.at/download.html.', but this website is not working.
kindly give any alternative solutions or from where to download 'DOWNLOAD STATCONNDCOM HOME&STUDENT'.
please help.
Saliesh,
You can integrate R with Qlikview, but you'll have to use the OpenCPU framework on a linux box https://www.opencpu.org/. The framework is maintained. Samuel Pena with Qlik has created an extension demonstrated at the Qlik conference the capabilities with R.
His open source project with R is located https://github.com/samuelpena
You can also email him at spa@qlik.com for further questions.
Saliesh,
You can integrate R with Qlikview, but you'll have to use the OpenCPU framework on a linux box https://www.opencpu.org/. The framework is maintained. Samuel Pena with Qlik has created an extension demonstrated at the Qlik conference the capabilities with R.
His open source project with R is located https://github.com/samuelpena
You can also email him at spa@qlik.com for further questions.
Hi Nick,
Are there any other ways of connecting R to Qlikview? I am running Enterprise Server, and I haven't had any success with the statconnDCOM connector. I would like to use OpenCPU, but our Qlikview server is a Windows box. We may be able to run a VM Ubuntu distribution, but I think that's a larger hurdle because of how our server is administered.
Thanks,
-Kristan
Not that I know of... If you have trouble using OpenCPU framework on Windows you can always use Cygwin, or as you suggested a VM or AWS running Ubuntu. Samuel might know of some other ways. You can always try to email him and ask.
Hi All,
EzDataMunch (www.ezdatamunch.com) has just released a fully compliant R connector for both QlikView and Qlik Sense. They also have a video of how this extension works with both Qlik Sense and Qlik View. It is a drag and drop functionality without writing any R program! It covers all the key analysis like Cluster analysis, Correlation analysis, Summary analysis including Cross tabs, Anova, Regression, Decision Tree and forecast models.
Here is the link to the website and video.
I found using execute command in load script is easier and faster than running it in the module.
For eg:
to execute R scripts, use code
EXECUTE "{source directory}\r.exe" CMD BATCH "{source directory}\{Rscript}.R";
I use this along with the reload button and thereby eliminating the need of complicated module scripts with connectors
Ram
Hi Ram,
I am trying to achieve this method. Can you elaborate a bit on the steps to follow to create this
Wow really? That'd be great. Everyone else here talks about Linux, CPU and stuff. Do you mind sharing a screenshot of a sample query? I'd like to see the format of what's the starting and what is the closing. Thanks a lot Ram!