topic Re: Copy (multiple) possible values into another field in QlikView

Copy (multiple) possible values into another field

chriys1337 — Tue, 11 Jul 2017 11:09:12 GMT

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

Re: Copy (multiple) possible values into another field

chriys1337 — Wed, 12 Jul 2017 09:50:25 GMT

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

Re: Copy (multiple) possible values into another field

marcus_sommer — Wed, 12 Jul 2017 14:20:21 GMT

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

Re: Copy (multiple) possible values into another field

vishsaggi — Wed, 12 Jul 2017 14:31:16 GMT

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?

Re: Copy (multiple) possible values into another field

chriys1337 — Wed, 12 Jul 2017 14:45:44 GMT

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!

Re: Copy (multiple) possible values into another field

chriys1337 — Wed, 12 Jul 2017 14:47:33 GMT

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!

Re: Copy (multiple) possible values into another field

antoniotiman — Wed, 12 Jul 2017 14:53:49 GMT

Hi Christian,

maybe this

Regards,

Antonio

Re: Copy (multiple) possible values into another field

marcus_sommer — Wed, 12 Jul 2017 14:56:08 GMT

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

Re: Copy (multiple) possible values into another field

chriys1337 — Wed, 12 Jul 2017 15:11:26 GMT

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

Re: Copy (multiple) possible values into another field

Anonymous — Wed, 12 Jul 2017 15:57:39 GMT

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.

Re: Copy (multiple) possible values into another field

marcus_sommer — Thu, 13 Jul 2017 06:59:16 GMT

I meant a search-string with the pipe as delimiter of the values and not just the exported dimension-values. Personally I don't need this very often in QlikView itself. Quite common are such search-strings instead with outside-values from users who needs data/views to a certain dataset. Mostly they are coming as excel-list or per mail and I create then the search-string in excel - it just needs a few seconds with an excel-expression.

In your case I would use like above mentioned an action which does the selection do. Further I could imagine to avoid these selections completely by adjusting my expressions appropriately, maybe with something like:

sum({< FieldA = p(FieldB) >} Value)

- Marcus

Re: Copy (multiple) possible values into another field

Anonymous — Thu, 13 Jul 2017 14:32:59 GMT

I agree with Marcus.

The only time I've even considering copying and pasting was when I had a longer list of values from a customer that I wanted to research in my dashboard on a detail level sheet.

For that I created an input box tied to a variable. A user could just copy and paste a list from Excel without worrying about pipes or anything.

Then I had another variable based on that that added the pipes and whatnot.

Then I tied an action to a button that would apply the search.

But I never tested it copying from one object to another.