topic Re: Drawing a straight line through points using R in Integration, Extension & APIs

Drawing a straight line through points using R

stevedark — Mon, 05 Dec 2016 12:54:49 GMT

Hi,

I've got R integration set up with Qlik Sense Desktop and all seems to be working okay. The example QVFs work fine and I have been able to send in two arguments and multiply them.

Unfortunately, I don't have any prior experience of using R.

Can anyone please advise how I can go about drawing a straight line through a set of values on a line chart?

Further to that, can someone advise how to extend that line n dimension values into future?

Thanks in advance.

Steve

Re: Drawing a straight line through points using R

stevedark — Mon, 05 Dec 2016 14:37:53 GMT

Just found someone that knows a bit of R in the building, have come up with this:

R.ScriptEval('lm(.arg2~.arg1)$fitted.values',Dim,Value)

And this:

R.ScriptEval('

a=.arg1

b=.arg2

lm1=lm(b~a)

predict(lm1,data.frame(a=seq(1,200,1)))

',Dim,Value)

Both seem to work well.

Re: Drawing a straight line through points using R

Anonymous — Wed, 07 Dec 2016 15:37:26 GMT

What extension are you using that gives you the ability to evaluate R scripts from QS?

Re: Drawing a straight line through points using R

stevedark — Wed, 07 Dec 2016 21:36:21 GMT

It's beta functionality, which is in the product already but is not publicly documented. You also need to install a plug in which is not yet publicly available.

Hopefully it will be ready for prime-time soon, and I will try to remember to post back to this thread when it is.

Steve

Re: Drawing a straight line through points using R

Anonymous — Thu, 08 Dec 2016 21:08:45 GMT

Please do.

Re: Drawing a straight line through points using R

martyginqo — Wed, 25 Jan 2017 18:05:20 GMT

Thanks for posting this Steve - very helpful for jumpstarting the process.

Martin

Re: Drawing a straight line through points using R

yvesqlik — Fri, 10 Feb 2017 12:14:18 GMT

Hi Steve,

Do you have any idea to calculate R² (R.squared)

Thanks!

Re: Drawing a straight line through points using R

stevedark — Fri, 10 Feb 2017 15:11:52 GMT

Hi Yves, What is R in this context? Is it a field? If so it is just R*R. If you are aggregating you will need a sum around it, e.g. sum(R*R).

Sorry if I have missed the point?

Re: Drawing a straight line through points using R

yvesqlik — Fri, 10 Feb 2017 15:34:08 GMT

Hi Steve,

R² ist a coefficient(variance) of regression in statistic,

you can use for it the function Linest_R2 in Qlik and in R: summary(lm(a~b))$r.squared. I tried to calculate this measure in a KPI-Chart with R but i didn't get it

Re: Drawing a straight line through points using R

stevedark — Fri, 10 Feb 2017 20:21:34 GMT

I thought I was probably missing something - should have taken the time to Google, it's been one of those days though.

Have you got any output from R coming into your app? Does the simple straight line work for you?