Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

1 Solution

Accepted Solutions
NickHoff
Specialist
Specialist

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.

View solution in original post

8 Replies
NickHoff
Specialist
Specialist

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.

View solution in original post

gshockxcc
Creator
Creator

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
Specialist
Specialist

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
Contributor II
Contributor II

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
Author

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
Contributor III
Contributor III

Hi Ram,

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

Littlelulu
Contributor
Contributor

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
Contributor II
Contributor II

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