Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Integrate R with Qlik Sense

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

1 Solution

Accepted Solutions
Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

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.

View solution in original post

12 Replies
Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

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
Partner - Creator III
Partner - Creator III

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

Anonymous
Not applicable
Author

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
Partner - Creator III
Partner - Creator III

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
Not applicable
Author

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

Capture1.PNGCapture2.PNGCapture3.PNG

Regards

DC

Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

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
Not applicable
Author

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
Partner - Creator III
Partner - Creator III

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
Not applicable
Author

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

Function Error.png