Skip to content

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

@simonegabrielli

Description

@simonegabrielli

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 ?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions