Qlikview and R integration

[#1]

‌hi, i have seen the cluster and predictive demo examples. But i am not able to run the macro beyond R.Init line.

I Have followed the documents - installed Dcom and rscproxy and R but dont know whether it is the installation causing issues, paths for qlikview and all these applications or something missing . I have seen the discussions aswell and a lot of people have actually asked this but nobody has got a reply. Please can anybody help

[migueldelval · Accepted solution]

Hi Hira,

I am going to attach an example that I have made.

I hope that this example help you.

CLUSTER:

LOAD [Customer Name],

     [Total Sales],

     [Total Order Quantity]

FROM

(biff, embedded labels, table is Hoja1$);

STORE CLUSTER into "C:\Users\mdvalle\Docu QLIK\EJEMPLOS\Qlikview_mas_R\datos.csv" (txt);

EXECUTE "C:\Program Files\R\R-3.2.4revised\bin\x64\r.exe" CMD BATCH "C:\Users\mdvalle\Docu QLIK\EJEMPLOS\Qlikview_mas_R\kmeans.r";

drop table CLUSTER;

CLUSTERACION:

LOAD Customer.Name as [Customer Name],

     Total.Sales as [Total Sales], 

     Total.Order.Quantity as [Total Order Quantity],

     cluster

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Regards

Miguel del Valle

[#3]

‌hi,

thanks

this is excellent. But how can i pass R data from a qlikview table chart which is on the front end and not in script?

[migueldelval]

Hi Hira,

Maybe you can meke a Macro to export the table to excel, execute R and reload .qvw to see the new file.

Regards

Miguel del Valle

[migueldelval]

Hi Hira,

I have been looking for some information about Macro to export data and this document I think that this document it´s good for your porpouse.

Loop Charts and Field Values - Excel Export Macro

Regards

Miguel del Valle

[#6]

‌excellent!!