topic Re: QlikView and R in QlikView

QlikView and R

Anonymous — Mon, 26 Jan 2026 16:26:21 GMT

Has anyone attempted getting QlikView and R talking to eachother?

I would like to do advanced statistical computing in R without having to go via Excel.

Thanks.

Joao.

Re: QlikView and R

hic — Thu, 01 Nov 2012 19:04:55 GMT

http://community.qlik.com/docs/DOC-2975

Re: QlikView and R

Anonymous — Fri, 02 Nov 2012 05:32:34 GMT

Thank you very much for this.

I will try it out.

Joao.

Re: QlikView and R

Anonymous — Fri, 02 Nov 2012 12:54:32 GMT

Hi Henric

Thank you very much for this. i have got it working. Unfortunately, I'm still fairly new to QlikView and want to learn what I can bring back into QlikView from R, slowly, by working through the lines of code in the example. I'm also concerned that certain things may not be possible to bring back.

I would therefore like to ask if there is anyway to see the information in R once it has been passed through. I have R open, and can pass the information through, but I can't see it in the R session. I think this is becasue the code initializes a new R session, but don't know if this is the reason.

Is there any way to pass the information through to R, and then go an play with it in R?

Thanks.

Joao.

Re: QlikView and R

elif-tutuk — Fri, 02 Nov 2012 21:49:47 GMT

Hi Joao-

The example that is available in the kit (Henric provided the link above) uses a R COM object to allow QlikView and R communication. This communication is 2 ways; QV can pass data to R, and QV can get data from R (Please note that the method that is used to get the data from R to QV -R.GetSymbol- may not be supported with the latest version of R, I think there is a new method but I did not have the chance to research). But the solution already does what you are asking. If you want to pass the data from QV to R, and then continue to interact with it in R, you can use the "copytoclipboard" option in QV to copy the selected data into clipboard and then you can use the R functionality to get the data from clipboard to R and continue to interact with the data in R. I hope this makes sense.

Thanks a lot,

Elif.

Re: QlikView and R

Anonymous — Sat, 03 Nov 2012 02:29:35 GMT

Thanks Elif.

I have resolved the problem by using Rcom instead of RDcom, which allows me to see the data passed through to R in my existing R session. I'll now work on understanding exactly what can be passed back into QV (data only, or other things like plots).

Thank you very much for the assistance.

Joao

Sent from my iPad

Re: QlikView and R

Anonymous — Wed, 07 Nov 2012 11:44:27 GMT

I'm now getting an error 'Type mismatch' when trying to update my values in QlikView. Unfortunately, I can't debug the code to see what is being pulled through and where it is failing. If anyone has any ideas, your input would be welcome.

Thanks.

Joao

Re: QlikView and R

Thu, 22 Nov 2012 06:20:29 GMT

I'm getting the same error!

I can get the data from R to Qlikview, with the correct count (check it by UBound), but I can't show any data, it will say "Type mismatch".

Re: QlikView and R

Thu, 22 Nov 2012 06:24:59 GMT

Hi Elif,

If the GetSymbol is not supported in the latest R, which verion of R is it supporting?

I wonder if the author of the demo can run the demo or not.

Martin

Re: QlikView and R

Anonymous — Thu, 22 Nov 2012 06:32:34 GMT

I got this to work by passing through one value at a time. Seeing as I was looping anyway to write the values into my data, I ask R for one value at a time.

Sent from my iPad

Re: QlikView and R

Thu, 22 Nov 2012 07:50:30 GMT

Thank you. It really works!

One data a time, very uncomfortable.

Re: QlikView and R

Anonymous — Thu, 22 Nov 2012 08:00:19 GMT

You're welcome.

I also change the connector to Rcom, and then I can see all my data in R directly, which makes it a lot easier to debug any problems. Try this out if you're having problems. Essentially, you're using the foreground server instead of the background server.

Sent from my iPad

Re: QlikView and R

Thu, 22 Nov 2012 08:10:35 GMT

Hi jcfrasco,

How can I change the connector to Rcom?

Martin

Re: QlikView and R

Anonymous — Thu, 22 Nov 2012 08:20:07 GMT

Will need to look when I'm back at work tomorrow. Will let you know then.

Sent from my iPad

Re: QlikView and R

Anonymous — Fri, 23 Nov 2012 05:29:06 GMT

Use this instead:

Set R = CreateObject("RCOMServerLib.StatConnector")

Joao

STANLIB disclaimer and confidentiality notice:

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of STANLIB. Any views or opinions presented are solely those of the author and do not necessarily represent those of STANLIB. This e-mail is subject to terms available at the following link: http://www.stanlib.com/Pages/Disclaimer.aspx.

STANLIB is an authorised financial services provider.

Re: QlikView and R

elif-tutuk — Sun, 25 Nov 2012 19:49:18 GMT

Hi Martin-

I can run the demo on my laptop. The R version that I am using is R 2.1.2.2.

Thanks a lot!

Re: QlikView and R

Wed, 28 Nov 2012 04:22:10 GMT

I've changed mine, but get this error "ActiveX component can't create object: 'RCOMServerLib.StatConnector' "

Should I download a new package from somewhere?

Re: QlikView and R

Anonymous — Wed, 28 Nov 2012 05:43:18 GMT

Hi Ivan

I don’t know enough about this to know whether it is a package issue, but I would try to re-download the packages. A few quick questions:

1. Does your full statement look like this: Set R = CreateObject("RCOMServerLib.StatConnector")

2. Did it work before you made the change?

3. Do you have the following packages: rcom and rcsproxy

Regards,

Joao

STANLIB disclaimer and confidentiality notice:

STANLIB is an authorised financial services provider.

Re: QlikView and R

agigliotti — Tue, 11 Dec 2012 15:10:45 GMT

Hi Elif,

I'm using R version 2.15.1 and the GetSymbol method doesn't works.

It seems to works only with no multidimensional array.

Is it possibile ? or maybe is it a bug ?

How can I fix it ?

I need to know what method I have to use to get data from R to QlikView.

Thanks in advance.

Best regards

Andrea

Re: QlikView and R

agigliotti — Tue, 11 Dec 2012 15:19:48 GMT

Hi Martin,

Could you please send me the VBScript code used (looping) to fix the .qvw example ?

Many Thanks

Regards

Andrea