topic Copy data in a cell in QlikView

Copy data in a cell

Tue, 26 Oct 2010 13:02:38 GMT

Hi,

Is it possible to copy a value in a single data cell (Straight Table) so it can be used in another applications.

I have a straight table to contain a list of all open Purchase Order. I want to be able to quickly copy a specific purchase order number and paste it to Oracle.

Can this be done or do I need to export to Excel and then copy?

Best Regards,

Jonas

Copy data in a cell

Tue, 26 Oct 2010 13:06:08 GMT

Copy to clipboard -> cell value

Greetz,

Dirk

Copy data in a cell

Tue, 26 Oct 2010 13:06:35 GMT

Right click on the cell, Copy to Clipboard, Cell value

Re: Copy data in a cell

Fri, 07 Oct 2011 12:46:10 GMT

I would like to create a method "getCurrentFieldIntoClipboard". So we can create a button where the user can "Copy to Clipboard" in just one click.

We have users that complain about it.

I know you can do that in 3 clicks but if we can do that in 2, one to select the cell and another to copy is too much easier. And of course you can export to excel and do this there but we can do this here too. May you help me?

---

I already solved my problem using the method like this:

sub GetCurrentFieldIntoClipboard

ActiveDocument.GetSheetObject("TB02").CopyValuesToClipboard

end sub

// TB02 is a hidden table with the field that I want to copy.

Thanks.

Re: Copy data in a cell

Anonymous — Wed, 05 Jun 2013 21:08:54 GMT

This is very helpful, thank you, providing I'm using the Qlikview client.
When viewing Qlikview through a web browser, "copy to clipboard" is not a right-click option.

Am I missing a checkbox in the table properties?

When I right-click on a table in a web browser, I get the following options;

Properties...

Notes >

Sort

Select Possible

Select Excluded

Select All

Clear All Selections

Clear

Clear Other Fields

Copy (which does not actually copy to the clipboard for other apps)

Print...

Send to Excel (I could use this but really really not preferrable)

Export...

Maximise

Anyone help please.
Elp

Re: Copy data in a cell

derekledbetter — Tue, 23 Jul 2019 13:31:44 GMT

Hi,

The option of "copy function" applies to charts and not a tablebox. I had the same issue asked of me and started researching.

Suggestion, to get this "copy", change tablebox to a chart. You will then see it.

QlikView Ver 12.20 SR9 - my version