Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview and R integration

‌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

1 Solution

Accepted Solutions
migueldelval
Specialist
Specialist

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

View solution in original post

5 Replies
migueldelval
Specialist
Specialist

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

Not applicable
Author

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

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

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

Not applicable
Author

‌excellent!!