Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Integrating 'R' with qlikview

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.

Tags (1)
1 Solution

Accepted Solutions
NickHoff
Valued Contributor

Re: Integrating 'R' with qlikview

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.

8 Replies
NickHoff
Valued Contributor

Re: Integrating 'R' with qlikview

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.

gshockxcc
Contributor

Re: Integrating 'R' with qlikview

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

NickHoff
Valued Contributor

Re: Integrating 'R' with qlikview

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.

milanmvd1
New Contributor II

Re: Integrating 'R' with qlikview

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.

http://ezdatamunch.com/r-package-integration-solution/

http://ezdatamunch.com/project/webinar-video-predictive-analytics-made-simple-using-qlik-r-user-focu...

Not applicable

Re: Integrating 'R' with qlikview

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

bhargavjm098
New Contributor III

Re: Integrating 'R' with qlikview

Hi Ram,

I am trying to achieve this method. Can you elaborate a bit on the steps to follow to create this

Littlelulu
New Contributor

Re: Integrating 'R' with qlikview

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!  

Sa20
New Contributor II

Re: Integrating 'R' with qlikview

I have the same problem.. have you found the solution ??
help me please