topic Cannot paste in Excel in QlikView

Cannot paste in Excel

Anonymous — Fri, 18 Jun 2010 14:30:59 GMT

I right click on chart, copy to clipboard, & select object & open excel 2007 as well as 2010 & paste. Nothing happens. What am I doing wrong?

Thanks,

Dinesh.

Cannot paste in Excel

fernandotoledo — Fri, 18 Jun 2010 15:36:59 GMT

Is your computer plugged in?

Just kidding!

What kind of client do you use? Desktop, plugin, ajax.. ?

If Desktop, are you trying to copy the data or the object? If the object, you have to install the IE plugin too.

Best regards,

Fernando

Cannot paste in Excel

Anonymous — Fri, 18 Jun 2010 15:42:12 GMT

I am trying to copy the object and am using the personal edition. Where do I get IE plugin & why does IE has anything to do with Excel?

Thanks,

Dinesh.

Cannot paste in Excel

Fri, 18 Jun 2010 16:56:12 GMT

I think there might be some mis-understanding here, you say you are right clicking, copy to clipboard and then OBJECT!!

If this really is the case then this wont work, the object is a specific QLIKVIEW item that will only do anything in QlikView, the copy function here is so you can duplicate an existing object. If you want to copy the chart into excel then you should select Copy to Clipboard, IMAGE.

However, if you want the data from the chart in excel then you should select send values to excel.

BUT.......

My second comment above "might" also be mis-leading, because QlikView can allow Excel/Powerpoint etc to interact with it and in this case you would want to copy an Object, but this functionality only works when you are using a QlikView server product, it won't work with personal edition.

On the IE Plug-In, you don't use it with personal edition!

Cannot paste in Excel

fernandotoledo — Fri, 18 Jun 2010 19:33:46 GMT

Hey Nigel,

In QV9 you can copy the OBJECT into MSOFFICE programs and use them as you do into qlikview. To make it work the plugin must be installed!

Dinesh, here in the community you can look for the plugin installer in the download session!

Cannot paste in Excel

Anonymous — Fri, 18 Jun 2010 19:46:18 GMT

Thx. I could not find the installer you talked about. Can you provide a link where this plug-in is available?

Cannot paste in Excel

fernandotoledo — Fri, 18 Jun 2010 19:58:50 GMT

Here is it:

http://d1cf4w4kkla6tb.cloudfront.net/qlikview/9.00/7469/_MSI/QvPluginRedist.exe

Normally you can access it from a QVServer accesspoint!

Best regards,

Fernando

Cannot paste in Excel

Mon, 21 Jun 2010 08:05:50 GMT

Hi to Both of you.....

Please see my ealier entry in this thread, I understand you can copy an object into Excel/Powerpoint as an active object, however, you need to be using QlikView server to do this, the plug-in is simply a thin client that accesses the application when it is running on the server.

So, to the original question, you are using QlikView Personal edition, so this does not and will not connect to a qlikview server, so this functionality is not available to you no matter whether you download the plug-in or not.

Regards,

Cannot paste in Excel

Mon, 21 Jun 2010 10:39:01 GMT

hi,

you want to copy the chart inside excel ...

see if you want to copy the chart data it's possible but about chart this i don't

coz the chart contain the date .

try to copy the chart again and it will copy for you the chart data hope this help you bro.

Regards,

Abdalla