Discussion Board for collaboration on Server-Side Extensions and Advanced Analytics Integration.
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
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.
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:
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.
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
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".
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
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);
Then I load this table in an other table to create cluester
X <- cbind(q$sL,q$sl,q$pL,q$pl)
Cluster = kmeans(X, centers = 3, nstart=20)$cluster
data.frame(Id = q$Id, Cluster);
Hope it'll help