Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Copy data in a cell

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

1 Solution

Accepted Solutions
Not applicable
Author

Copy to clipboard -> cell value

Greetz,

Dirk

View solution in original post

5 Replies
Not applicable
Author

Copy to clipboard -> cell value

Greetz,

Dirk

View solution in original post

Not applicable
Author

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

Not applicable
Author

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.

elpmasjj
Contributor II
Contributor II

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

derekledbetter
Contributor III
Contributor III

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