topic Re: Integrating 'R' with qlikview in QlikView

Integrating 'R' with qlikview

Fri, 02 Jan 2015 12:08:29 GMT

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.

Re: Integrating 'R' with qlikview

NickHoff — Fri, 02 Jan 2015 18:44:19 GMT

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.

Re: Integrating 'R' with qlikview

gshockxcc — Thu, 09 Apr 2015 12:00:03 GMT

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

Re: Integrating 'R' with qlikview

NickHoff — Thu, 09 Apr 2015 12:24:39 GMT

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.

Re: Integrating 'R' with qlikview

Anonymous — Wed, 07 Sep 2016 04:58:38 GMT

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-focused-approach/

Re: Integrating 'R' with qlikview

Fri, 04 Nov 2016 22:08:43 GMT

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

Re: Integrating 'R' with qlikview

Anonymous — Thu, 01 Mar 2018 08:52:20 GMT

Hi Ram,

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

Re: Integrating 'R' with qlikview

Littlelulu — Tue, 19 Mar 2019 03:40:23 GMT

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!

Re: Integrating 'R' with qlikview

Sa20 — Fri, 31 May 2019 10:09:58 GMT

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