topic Re: Load R dataframe into Qliksense in Integration, Extension & APIs

Load R dataframe into Qliksense

chaitanyajami — Sat, 16 Nov 2024 07:58:58 GMT

Hi All,

I have a requirement to load dataframe created in R into qliksense , attached is the details. can someone help me with the syntax to load the dataframe into qliksense.Thank you

Re: Load R dataframe into Qliksense

Anonymous — Tue, 10 Jul 2018 15:44:00 GMT

Here's a good link

Integrating QV with R example kit.zip

Re: Load R dataframe into Qliksense

chaitanyajami — Wed, 11 Jul 2018 03:31:22 GMT

Hi Carter,

Thanks for the response,in April 2018 qliksense, we can load the data from R to Qliksense without writing macros,

i would like to get help on syntax if you have idea.

Re: Load R dataframe into Qliksense

asiic999 — Wed, 11 Jul 2018 17:21:15 GMT

Hello, I'm just in the process, with the integration you mention (AAI), the first thing I'll do is investigate what the default functions of the connector do:

R.ScriptEvalStr

R.ScriptEvalExStr

R.ScriptEvalEx

R.ScriptEval

R.ScriptAggrStr

R.ScriptAggrExStr

R.ScriptAggrEx

R.ScriptAggr

Re: Load R dataframe into Qliksense

Anonymous — Thu, 12 Jul 2018 07:39:18 GMT

Hi chaitanya‌!

Based on your post I'm not sure on how familiar you are with SSE (Server Side Extensions). Have you taken a look at the R-plugin (https://github.com/qlik-oss/sse-r-plugin)? There is a Get Started guide in the repo explaining how to configure the plugin and run the examples provided. If you're not familiar with SSE I recommend you to first take a look at our main repository (https://github.com/qlik-oss/server-side-extension) before looking into the R-plugin example, which explains the protocol and its functionality as well as provides examples in different languages.

Kind regards,

Josefine

Re: Load R dataframe into Qliksense

chaitanyajami — Thu, 12 Jul 2018 08:07:57 GMT

Hi Josefine,

Thank you,i have installed SSER Plugin in qliksense setup, dont know how start extacting this data frame into qliksense. i just need to bring data in to sense, thats it

Re: Load R dataframe into Qliksense

vasil_gutev — Thu, 12 Jul 2018 08:51:50 GMT

Hi ,

try this way:

emp_data:

Load*

Extension R.ScriptEval('emp.data;');

Re: Load R dataframe into Qliksense

chaitanyajami — Wed, 18 Jul 2018 07:17:49 GMT

Hi Vasil,

iam getting below error, do you have any idea what could be done. all the services are up and running.

Re: Load R dataframe into Qliksense

vasil_gutev — Wed, 18 Jul 2018 07:33:38 GMT

Hi Chaitanya,

please check all of the columns data types and convert them to string, because some R data types aren't supported in Qlik. Later in Qlik Sense you can convert them again to "Date" and "Num".

Re: Load R dataframe into Qliksense

yannick_c — Wed, 25 Jul 2018 09:48:48 GMT

Hello,

I don't think you can load directly a data frame from R to Qlik Sense, maybe you should try to export your data in csv.

Please find how I load data frame with the Iris data:

First I am importing the CSV file

[Iris]:

LOAD

*

FROM [lib://Data/Iris.csv]

(txt, codepage is 28591, embedded labels, delimiter is ',', msq);

Then I load this table in an other table to create cluester

[Cluster]:

Load *

Extension

R.ScriptEval('

          X <- cbind(q$sL,q$sl,q$pL,q$pl)

          Cluster = kmeans(X, centers = 3, nstart=20)$cluster

          data.frame(Id = q$Id, Cluster);

',Iris{Id,sL,sl,pL,pl});

Hope it'll help

Regards

Re: Load R dataframe into Qliksense

vasil_gutev — Mon, 30 Jul 2018 06:55:27 GMT

Hi Yannick,

You can load a data frame and I did it lots of times. The only problems i had was with data types that Qlik Sense could not use like factor.

Re: Load R dataframe into Qliksense

spgurucse — Wed, 27 Mar 2019 10:34:33 GMT

Hi, can you please share the load script for loading R data frame into qlik sense.

Re: Load R dataframe into Qliksense

proctors — Thu, 07 Nov 2019 03:17:35 GMT

Get the load script?

Re: Load R dataframe into Qliksense

Saturnina — Mon, 25 Nov 2019 10:58:08 GMT

Hi there, would you be so kind to post an example of a load script to read an R dataframe please?

Thanks