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

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