topic Re: Run Basic .R Script in Qlik Sense in Integration, Extension & APIs

Run Basic .R Script in Qlik Sense

Sat, 16 Nov 2024 09:14:55 GMT

I am trying to run a basic R script that does text mining for the I Have A Dream speech (see attached). I am trying to have Qlik both run the R script and have Qlik pick up the output for visualization (high frequency words). The SSE plugin is installed and although I have successfully test the R.ScriptEval and R.ScriptAggr functions, I am having difficulty testing this more intermediate level use case. Any guidance will be helpful. Thank you.

Re: Run Basic .R Script in Qlik Sense

Anonymous — Wed, 27 Sep 2017 15:26:52 GMT

Hi, Kwon,

Have you have a look at Brian Bauers post: Qlik AAI Load Script Example - R (Qlik Sense and QlikView)

This may be what you're looking for.

Regards,

Bas.

Re: Run Basic .R Script in Qlik Sense

Wed, 27 Sep 2017 16:52:32 GMT

Hi Bas,

I have studied Brian Bauer's post and have successfully run the Comorbidity app (very helpful). I tried to mimic the script logic using the following script below but encounter an argument error:

SET QvWorkPath='C:\QlikWarehouse\POC Development\Comorbidity\Qlik AAI Load Script Example - R';

SET RSource='$(QvWorkPath)\R\MLKJR.R';

LOAD

R.ScriptEval('starttime <- proc.time(); source(q$RSource); elapsed <- proc.time()-starttime; toString(unname(elapsed["elapsed"]));', RSource) as [Elapsed Time];

LOAD

'$(RSource)' as RSource

Autogenerate 1;

Re: Run Basic .R Script in Qlik Sense

Steven_Pressland — Mon, 09 Oct 2017 11:32:57 GMT

if you want to do this is real time as a chart expression (with changes based upon selection), then to get a different granularity of input data to output data then the best way is to use an AGGR function.

But as per the previous answer, if you just need it as a one time thing against the whole data set, then running in the script is a better option.

Re: Run Basic .R Script in Qlik Sense

Dalton_Ruer — Sun, 17 Feb 2019 20:29:33 GMT

Use the R.ScriptEvalStr function instead since you are exporting the elapsed time as a string. i found this while trying to use a word cloud based on text loaded from other tables and ran into the same problem and get my wordcloud.png generated via this script:

SET RSource='c:\weaknessscript.r';

R:
LOAD *,
R.ScriptEvalStr('starttime <- proc.time(); source(q$RSource); elapsed <- proc.time()-starttime; toString(unname(elapsed["elapsed"]));', RSource) as [Elapsed Time];

LOAD
'$(RSource)' as RSource
Autogenerate 1;