Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
chriys1337
Creator III
Creator III

Copy (multiple) possible values into another field

Hi,

would like to copy 10 ID's from field A with right click, "copy possible values" into another field B.

Is there any trick how to do it? When I paste the values into a text document, all IDs are one below the other.

But when I try to paste it into field B it doesn't work.

Any ideas?

Thank you!

Chris

11 Replies
chriys1337
Creator III
Creator III
Author

Nobody any idea, I thought that must be possible...?

marcus_sommer

Do I understand it right that you want to transfer selections from one field to another field? If yes, your search-string for the second field need to be look like: ("Value A"|"Value B"|"Value C"). You could create such an output within a textbox or a variable and copy it there to apply it on the second field. Maybe a bit easier would it be to use such a string within an actions triggerred by a button.

- Marcus

vishsaggi
Champion III
Champion III

Can you explain a little more with some expected output you are looking. What values does your field A and FieldB has can you share some sample data?

chriys1337
Creator III
Creator III
Author

I tried it with copying my IDs to a txt and put 2 brackets () and also seperators | there, but it did not work. I will try it with " ", which I did not do up to now.

It looked sth like this: (2346|4555|1235|4570).

Thank you!

chriys1337
Creator III
Creator III
Author

Hi,

its really simple, I just want to manually copy IDs from one field to another, not one by one, instead all selected.

Keen on your answer, thanks!

antoniotiman
Master III
Master III

Hi Christian,

maybe this

Regards,

Antonio

marcus_sommer

The double-quotes are only needed if your values contain spaces and/or any special chars. For me worked this approach very well whereby you couldn't just past it on the listbox else you need to activate at first the search-mode. This meant activating the listbox, typing a char, pressing back-space to remove this char and now you could paste your search-string from the clipboard.

Quite often I leave the brakets out of the search-string and start with enter the opening braket, paste the search-string and enter the closing-braket.

- Marcus

chriys1337
Creator III
Creator III
Author

Thank you for sharing your experience.

So you are copying the IDs, click on field 2, activate the search put the first bracket there and paste your copied values and close it with another bracket.

But how are you adding all these | seperators?

Kind Regards,

Chris

Anonymous
Not applicable

What Antonio said.  See attachment.

You can make it run off of a button or automatically when a selection in the first listbox is made.