topic Re: Copy selection data on straight table like in Excel in QlikView

Copy selection data on straight table like in Excel

sifatnabil — Wed, 17 Feb 2016 17:38:20 GMT

Hi all,

I have a straight table but I would like to Ctrl+C or right click & copy multiple values in a single column just like how you could Ctrl+C rows A1 to A10 in Excel. I can then paste these values to an external notepad or chat window.

Currently I can't do this on a straight table, as dragging down a column and right clicking only allows the options:

Copy Full Table

Copy Table Data Area

Copy Cell Value

Is there any way I can just copy a single column of values that I've selected?

Re: Copy selection data on straight table like in Excel

marcus_sommer — Wed, 17 Feb 2016 17:48:19 GMT

No, I don't think this is possible in this way. Maybe you could reduce these table or a copy from them with various selections and/or variable-values as conditions fro dimensions and expressions but I think this could be quite difficult and would require additionally user-actions - which meant an copy/export to excel and a selections there on the wanted area and copy them again would be easier and probably faster.

- Marcus

Re: Copy selection data on straight table like in Excel

Gysbert_Wassenaar — Wed, 17 Feb 2016 18:01:20 GMT

No. The easiest way is to copy the entire table to excel and remove the columns you don't need there. Alternatively you can create a table in Qlikview that contains only the column you want.

Re: Copy selection data on straight table like in Excel

sifatnabil — Wed, 17 Feb 2016 18:23:12 GMT

Yeah I'll use a single column straight table, as this reduces the steps needed to copy the values. I think Qlik should build keyboard shortcuts for copy/paste like they have with objects. It would be great if the straight tables could behave just like Excel tables in terms of highlighting and copy/paste.

Re: Copy selection data on straight table like in Excel

sifatnabil — Thu, 18 Feb 2016 11:54:51 GMT

Guys, I found a neat solution to this. If it's a single column that you need to copy paste like in my case, create a straight table with that column, and create a macro like this:

Sub Copy

ActiveDocument.GetSheetObject("CHXX").CopyValuesToClipboard

End sub

Then create a button on the front-end to run this macro and get the value(s) you selected straight into your clipboard for pasting elsewhere. Better way is to create a field event trigger on the column to run the macro. This circumvents having to right click -> Copy and having too many options to choose from. Other methods you can use:

CopyValuesToClipboard

CopyTextToClipboard

CopyTableToClipboard

So much easier than the right click option.

Re: Copy selection data on straight table like in Excel

dgreenberg — Thu, 18 Feb 2016 14:42:41 GMT

Sifat ,

will that work through access point?

Many years ago there were web exploits that would read your clipboard and then everyone became aware of the exploit and the ability to read/write the clipboard has often been restricted.

Re: Copy selection data on straight table like in Excel

sifatnabil — Thu, 18 Feb 2016 17:39:43 GMT

Hi Dan - I haven't tested it through the web. Currently I'm trying to circumvent the accesspoint and deliver this as a desktop solution where there's more flexibility in regards to running macros. I don't control the QV server, hence working around it.