search

konne / RserveCLI2

A fork of RServeCLI
Other
30 stars 21 forks source link

Can I use all R libraries in Qlik Sense Desktop, and call them in the Load Script Editor ? #70

Open simonegabrielli opened 5 years ago

simonegabrielli commented 5 years ago

Hi everyone, this is my script: DEALOAD: LOAD DMU, INPUT1, INPUT2, OUTPUT1, OUTPUT2, OUTPUT3, OUTPUT4

FROM [lib://dati/deaDB.xlsx] (ooxml, embedded labels, table is Sheet1);

SSELoad: Load INPUT1, INPUT2, OUTPUT1, OUTPUT2, OUTPUT3, OUTPUT4,

R.ScriptEval('cbind(q$INPUT1, q$INPUT2);', INPUT1, INPUT2) as X,

R.ScriptEval('cbind(q$OUTPUT1, q$OUTPUT2, q$OUTPUT3, q$OUTPUT4);', OUTPUT1, OUTPUT2, OUTPUT3, OUTPUT4) as Y

Resident DEALOAD;

SSEload2:

LOAD X, Y,

R.ScriptEval('library(Benchmarking); dea(q$X, q$Y);', X, Y) AS DEA

Resident SSELoad;

At the end I have this error from SSEtoRserve:

Evaluating library(Benchmarking); dea(q$X, q$Y); SSEtoRserve.RServeEvaluator|Param names: X Y Cannot decode an Sexp because the type is not recognized: 48.

There is an error in the script or Qlik Sense can not read the R library Benchmarking ?

Yusuf90 commented 5 years ago

The syntax looks quite different compared to our call to a R evaluator. I think this question belongs in here