I recently finished a test of data integration of Qlikview and R. I used data from Indian Water Quality project at Kaggle to develop a prototype for plotting a heatmap upon setting a filter in Qlikview dashboard. Thanks to Brian Bauer (bbu) for his post QlikView and R Integration for Predictive Analytics Example the which I used as reference for this development.
Upon clicking on the button "Generate Heat Map" a VB script is executed to initiate a session in R and plot a heatmap using ggplot library.
The procedure followed to generate such a graph was
1.- Export data from Qlikview to a CSV text file
2.- Declare and initialise a R session using library StatconnDcom
3.- Prepare data using a R function sourced from Github
4.- Plot the heatmap using function draw_hm, that call in turn ggplot function, into a png file
Below you can see the VB script used for this purpose. Enjoy!
' Export the selected patient data to be scored.
Set myTable = ActiveDocument.GetSheetObject("DataSentToR")