topic Re: Is it possible to copy past a list of values into a selection box? in QlikView

Is it possible to copy past a list of values into a selection box?

lmonincx — Thu, 20 Jun 2013 06:58:18 GMT

Hi,

Is there a way to copy a list of values, i.e. 1234,5678,9100 into the selection "DeptId", in order to select those values with only a paste action, without selecting them manualy one by one?

Hope this is possible, would make live much easier

Kind regards,

Linda

Re: Is it possible to copy past a list of values into a selection box?

flipside — Thu, 20 Jun 2013 10:39:45 GMT

Hi Linda,

Create an inputbox so you can paste the comma-separated list into a variable. Then create an action linked to e.g. a button to select in your field this formula ...

='(' & Replace('$(vList)',',','|') & ')'

... where vList is your variable. All it does is replace the commas with pipe symbols and wrap brackets around the list.

flipside

Re: Is it possible to copy past a list of values into a selection box?

AbhijitBansode — Thu, 20 Jun 2013 12:33:56 GMT

May be, you would also like to have a look on this very useful post by Barry Harmsen.

Regards,

Abhijit

Re: Is it possible to copy past a list of values into a selection box?

swuehl — Thu, 20 Jun 2013 12:57:28 GMT

If your numbers are all of the same length, try creating your list of values space separated

1234 5678 9100

then copy the line into the search bar of your list box. Press Enter.