topic Re: Integrate R with Qlik Sense in Management & Governance

Integrate R with Qlik Sense

Anonymous — Tue, 23 Jan 2018 05:20:20 GMT

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

Re: Integrate R with Qlik Sense

Ralf_Heukäufer — Tue, 23 Jan 2018 07:03:53 GMT

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 to perform advanced …

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.

Re: Integrate R with Qlik Sense

Ralf_Heukäufer — Tue, 23 Jan 2018 07:07:30 GMT

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

Re: Integrate R with Qlik Sense

Anonymous — Tue, 23 Jan 2018 10:58:58 GMT

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

Re: Integrate R with Qlik Sense

Ralf_Heukäufer — Tue, 23 Jan 2018 11:16:56 GMT

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

Re: Integrate R with Qlik Sense

Anonymous — Tue, 23 Jan 2018 15:44:05 GMT

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

Re: Integrate R with Qlik Sense

Ralf_Heukäufer — Wed, 24 Jan 2018 06:52:45 GMT

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.

Re: Integrate R with Qlik Sense

Anonymous — Wed, 24 Jan 2018 08:50:33 GMT

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

Re: Integrate R with Qlik Sense

Ralf_Heukäufer — Wed, 24 Jan 2018 09:27:01 GMT

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-functions

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

Re: Integrate R with Qlik Sense

Anonymous — Wed, 24 Jan 2018 09:36:41 GMT

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

Re: Integrate R with Qlik Sense

Anonymous — Wed, 24 Jan 2018 11:05:32 GMT

Got the answer for it.. Thanks!!

Regards

Re: Integrate R with Qlik Sense

MoaMattsson — Mon, 23 Sep 2019 06:12:08 GMT

Hi,

I am facing the same problems as you are describing. Do you remember how you solved it?

Best regards,

Moa Mattsson

Re: Integrate R with Qlik Sense

rafael_carmo_ri — Mon, 02 Mar 2020 22:09:21 GMT

Hi!

Could you help me with this?

I´m facing the same issues you have mentioned in this thread. I have no idea what to do to fix this.

I would appreciate your help since you got an answer.

Thanks a lot in advance.

Regards

Re: Integrate R with Qlik Sense

Oke — Thu, 24 Oct 2024 12:05:26 GMT

An old topic but in case someone still faces the same issue:

I was just struggling with the same thing. I think you need to add value ".\FuncDefs.json" in SSEtoRserve.exe.config definition's "functionDefinitionsFile" setting:

<setting name="functionDefinitionsFile" serializeAs="String">
<value>.\FuncDefs.json</value> 
</setting>

Then you need to restart Qlik services and/or SSEtoRserve in correct order (not sure what's the minimum).