Integrate R with Qlik Sense

[Anonymous]

Hello Everyone

I am working on integrating R and Python with QLIK Sense. I go through so many documents.

Is anyone have step by step procedure to connect these with QLIK sense

Any help would be highly appreciated!!

Regards

DC

[Ralf_Heukäufer · Accepted solution]

Hello,

you can use this at first

Installing R with Qlik Sense.pdf

After the Installation you can use:

1. The Advanced Analytics Toolbox

Qlik Branch

GitHub - mhamano/advanced-analytics-toolbox: Qlik Sense extension which allows you to create charts ...

Under the Point Installation (in GitHub) you find the required R Packages you need to install for this Extension

2.  The Advanced Analytics Expression Builder

Qlik Branch

If you only want to use Expressions in the Qlik Sense Visualizations.

[Ralf_Heukäufer]

If you have any further question i have a running R System with R Server.

[Anonymous]

Hello Ralf

Thank you so much for your response.

I am currently working on it. Could you please help me to know how to stop "Rserve". I did a mistake so wanted to re-install everything but somehow I am not able to delete old files. It shows Rserve is still running

Thanks again!!

Regards

DC

[Ralf_Heukäufer]

Have you installed it as a service?

Then you must stop the service before

In the other case try

> RSshutdown(rsc)

or
> RSshutdown(rscd)

in the R  Console

[Anonymous]

Thank you so much sir!!

I have few more queries....

• My QLIK is installed on the server and we are sourcing the hub link of the server on local desktop. Do we need to always open the SSEPlugin and Rserve.
• My some visualization are working fine, however some are showing a error. Please guide me on that also

Regards

DC

[Ralf_Heukäufer]

For your first screenshot i think you must download the visualisation for that in R.

For your second and third screenshot i think there is something wrong in your query to the R Server.

[Anonymous]

Thank you sir

I got few reasons.. One of them is we have declared the functions in FuncDefs.json file SSEPlugin.

As per the link you have provide we need to call that in function Defination file as

functionDefinitionsFile : Default empty (no defined functions added). Set to i.e. .\FuncDefs.json or any other file to add your own defined SSE functions. The file should contain the description of the functions you want available. See chapter below for more info.

Could you please help me where this file is located ?

Thanks a lot for all your help!!

Regards

DC

[Ralf_Heukäufer]

I think you are on the right place:

https://github.com/qlik-oss/sse-r-plugin/blob/master/GetStarted.md#defining-and-using-your-own-funct...

But I am not sure. We don't need to change or add functions in our workcase.

[Anonymous]

I think we need it sir

In the attached screenshot we are using R.ConcatStringsTensor function but this function is user defined so I think we need to map it