Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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?
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
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
excellent!!