Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
simonegabrielli
New Contributor

Qlik Sense and R integration: R library

Hi everyone, in the installation PDF guide are indicated the following  R library:

 

install.packages("jsonlite", lib = "C:\\R\\R-3.6.1\\library")

install.packages("ChainLadder", lib = "C:\\R\\R-3.6.1\\library")

install.packages("forecast", lib = "C:\\R\\R-3.6.1\\library")

install.packages("rpart", lib = "C:\\R\\R-3.6.1\\library")

install.packages("d3r", lib = "C:\\R\\R-3.6.1\\library")

install.packages("partykit", lib = "C:\\R\\R-3.6.1\\library")

install.packages("tseries", lib = "C:\\R\\R-3.6.1\\library")

install.packages("colorspace", lib = "C:\\R\\R-3.6.1\\library")

 

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

I tried to use the library (Benchmarking) but does not work. In SSEtoRserve the error is: Cannot decode an Sexp because the type is not recognized: 48

the script is the following: 

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;

 

Qlik can not work with this R library, or there is an error in the script ?