topic Re: Qlikview and R integration in QlikView

Qlikview and R integration

Wed, 25 Nov 2020 16:16:04 GMT

‌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

Re: Qlikview and R integration

migueldelval — Thu, 23 Jun 2016 08:51:20 GMT

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

Re: Qlikview and R integration

Thu, 23 Jun 2016 08:56:58 GMT

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

Re: Qlikview and R integration

migueldelval — Thu, 23 Jun 2016 09:09:17 GMT

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

Re: Qlikview and R integration

migueldelval — Thu, 23 Jun 2016 09:15:55 GMT

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

Re: Qlikview and R integration

Thu, 23 Jun 2016 09:42:45 GMT

‌excellent!!