Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

SSEtoRserve only returning 1 row that I cannot display?

Hi, I'm attempting to figure out how to implement the ability to use R functions such as variance and linear correlation in my dashboard.

I'm currently using loaded data and trying to figure out how to find the standard deviation between two vectors of numbers. Here is my current expression I'm using in a KPI set (tried Tables etc. with no other success).

R.ScriptEval('sd(q$amt);', [SLM License (converted)] as amt)

However, this just returns me a - sign (null).

Here is the SSEtoRServe log:

2018-06-28 10:51:38.2609|INFO|SSEtoRserve.RServeEvaluator|EvaluateScript called from client (ipv6:[::1]:53753), hashid (62474978)

2018-06-28 10:51:38.2609|DEBUG|SSEtoRserve.RServeEvaluator|EvaluateScript header info: AppId (***********************************************.qvf), UserId (Personal\Me), Cardinality (1 rows)

2018-06-28 10:51:38.2639|INFO|SSEtoRserve.RServeEvaluator|EvaluateScript call with hashid(62474978) got Param names:  iotamt

2018-06-28 10:51:38.2639|DEBUG|SSEtoRserve.RServeEvaluator|Evaluating R script, hashid (62474978): sd(q$iotamt);

2018-06-28 10:51:38.2639|INFO|SSEtoRserve.RServeEvaluator|Rserve result: 1 rows, hashid (62474978)

2018-06-28 10:51:38.2639|DEBUG|SSEtoRserve.RServeEvaluator|Took 4 ms, hashid (62474978)

0 Replies