Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Feb 8, 2023 6:18:53 AM
Apr 2, 2013 5:16:51 PM
If you have never thought about integrating predictive analytics and QlikView, may this article pique your interest on the topic. If you have thought about the potential, but do not know how to get started, may this be the motivation to start your journey.
This demo example illustrates the art of the possible around the interoperability of the R statistics engine and QlikView 11 for enabling predictive algorithms within QlikView today.
R (http://www.r-project.org/) is a free software environment for statistical computing and graphics, which supports predictive modeling and scoring. The example also introduces Rattle (Rattle: A Graphical User Interface for Data Mining using R -- http://rattle.togaware.com/). Rattle was used to create the predictive model and generate the R code implemented within the example QlikView application. The use of Rattle is not detailed here. It is left up to you to explore.
The example assumes you understand R and how to create predictive models in R and how scoring works in R. If you understand how to do those things in R and you know how QlikView works, this example should give you an idea of how:
-- all without the end user having to leave QlikView.
As in the previous example posted by Elif Tutuk, "Integrating QV with R example kit.zip" (http://community.qlik.com/docs/DOC-2975), the example utilizes statconnDCOM. A slightly different approach in this example overcomes a break in functionality introduced into that earlier example by the changing in the behavior of one of the COM API methods in the most recent releases of statconnDCOM.
The integration is done using QlikView's built-in VBScript support to interoperate with the DCOM-based API. This is just one way to integrate with R. With a little research you can discover other potential opportunities for R integration (e.g., OpenCPU). Also, note that R is just one such example of a statistical engine being integrated with QlikView. Other solutions, such as commercially available statistical engines or predictive scoring engines may also be integrated in similar ways.
To get started with this example, save the attached file, QlikView-R_Predictive_Demo.zip, to your system. Open the zip file, and copy the enclosed folder (QlikView-R_Predictive_Demo) to a location of your choice. The location is not important as the example is portable and has no dependency on being placed in a particular folder on your system. Now navigate into the folder you just extracted and find the document named “Qlikview-R Integration Demo 20170310.pdf”. Open the document and follow the instructions step-by-step.
UPDATE (May 7, 2014): I updated the installation document (Qlikview-R Integration Demo 20140421.pdf) to eliminate the RAndFriends installer as it has been unavailable for some time. This edition of the document references R 3.1.0. Hopefully the instructions will continue to be a good guide for subsequent versions as well. I will continue to monitor for changes in R, statconnDCOM and other R components which could effect how the demo application works going forward. The example QlikView application itself remains unchanged. It is a Personal Edition version, so you should be able to explore it with a licensed QlikView Desktop or the Personal Edition. Thank you for your continued feedback on this demo.
UPDATE (September 21, 2015): Everyone who has been seeing the message "The license that is embedded in this document is not valid": I attached an updated version of QlikView-R_Predictive_Demo.zip. Ensure you overwrite the old QVW with the new one in this package. That is the only change. Please forgive this looooong overdue update.
UPDATE (October 9, 2016): Updated the embedded license to work with QlikView Desktop Personal Edition.
UPDATE (February 2, 2017): Updated the embedded license to work with QlikView Desktop Personal Edition.
UPDATE (March 10. 2017): A dependency for this particular example is statconnDCOM from the team at autstat (http://www.autstat.com/). If you wish to utilize statconnDCOM, you will need to contact autstat directly and purchase a license or request an evaluation license for testing.
I have run into the same issue as you have identified. Did you ever figure out what is wrong?
Hello Brian,
First, thank you very much for this integration it really worked good for me. I have a question in the sheet "Risk of Mortaly Plots" exactly in the figure of the decision tree, there is a variabe called vMaxPlot that can get the plot bigger when a user click on the plot. My question is i do not find the code of what this variable is doing. I want to do the same on my plots but i couldn't. Please any help on this issue.
Thanks in Advance.
did anyone installed the R version 3.2.1? its not working for me when I run
install.packages(c("rscproxy","rcom"),repos="http://rco
m.univie.ac.at/download",lib=.Library)
Hi Brian,
I tried downloading Rcom package but it is not working for R v2.13.1, v3.0.2 and v3.2.1.
I downloaded all other things n tried using solutions provided in comment chain. Is there any simple n specific way of implementing this R QV connection. I dont have knowledge of R.
Thanks and Regards,
Poshkant Sharma
Did you find any solution same problem with me..
Unfortunately, I did not find a solution for this...
Hi,
I installed : R-3.1.0
Statconnector:3.6-0B2 Noncommercial
"Loading 32 Bit StatConnector Server... Done
Initializing R...Function call failed
Code: -2147221455
Text: licensing: license expired
Releasing StatConnector Server...Done"
I'd be very grateful if you could help me to resolve this problem
Hi Brian,
I'm writing in connection with the subject of the communication betwwen R et Statconnector.
I installed : R-3.1.0
Statconnector:3.6-0B2 Noncommercial
"Loading 32 Bit StatConnector Server... Done
Initializing R...Function call failed
Code: -2147221455
Text: licensing: license expired
Releasing StatConnector Server...Done"
I'd be very grateful if you could help me to resolve this problem
Best regards
Hi Brian,
I have followed you in the installation step by step but when I wanted to run the QlikView Demo File I have received an error message "The licence that is embedded in this document is not valid". So I have reinstalled everything as follows:
1) R v3.0.2
2) The statconn dcom available in this link: statconn
Through the installation of R I have followed the recommands shown in this link: wiki:how_to_install - Information about statconnDCOM, rcom, and RExcel
I have also reupload the required libraries : "rscproxy", "rcom" and "rattle" as well. After successfully having these libraries I have ensured that their folders are in the library folder under the R installed folder. I have tried to test the connexion within the statconnector Test I still have the failed message, though. When I have even tried to launch the Demo File with QlikView, nothing works and the same error message "The licence that is embedded in this document is not valid" pops up.
Please I do really need your help! I can't figure out where is the problem knowing that I've really followed every single steps you have above mentioned
Lot of thanks !!
Hi,
Here, we are using statconn ie., connector which is developed with .net program to connect R.
My question is cann't we connect R with out using Statconnt.