topic Re: Listbox - select multiple values from clipboard (SAP,Excel,..) in QlikView

Listbox - select multiple values from clipboard (SAP,Excel,..)

Anonymous — Fri, 20 May 2016 08:47:21 GMT

Hello,

I would like (such as in other Systems possible, for example SAP) easily select multiple values from the clipboard in a list box, which I have previously compiled in an Excel spreadsheet. Is there a way?

Thank you very much

Mfg Sabrina Sekler

Re: Listbox - select multiple values from clipboard (SAP,Excel,..)

berndjaegle — Fri, 20 May 2016 09:28:34 GMT

Hi Sabrina,

I understand that you like to copy a list of multiple values.

You can concatenate the values.

Compound search

Using a compound search, you can express more complicated search conditions with logical operators. Use brackets and ‘&’ or ‘|’, e.g. ‘(California|Nevada)’.

hic‌

The Search String

Best regards,

Bernd

Re: Listbox - select multiple values from clipboard (SAP,Excel,..)

Kushal_Chawda — Fri, 20 May 2016 09:31:18 GMT

I am not very clear what you are trying to do. Can you please elaborate more?

Re: Listbox - select multiple values from clipboard (SAP,Excel,..)

miguelbraga — Fri, 20 May 2016 10:36:18 GMT

Hey Sabrina,

Did you tried using bookmarks to solve your problem? Can you please describe better your issue with some screenshot example or a document or even a QVD?

Hope it helps

Regards,

Re: Listbox - select multiple values from clipboard (SAP,Excel,..)

tresB — Fri, 20 May 2016 10:47:50 GMT

Have a look here : Compound Search - demystified | Qlik Community . That might help you.

Re: Listbox - select multiple values from clipboard (SAP,Excel,..)

Anonymous — Fri, 20 May 2016 11:58:50 GMT

I have for example a big Excel sheet with a lot of different customer numbers. These customer numbers want to select in the Dashboard.

Until now, I do this:

But for example 100 different customer numbers it is very costly.

Is there a simple solution?

Thanks

Re: Listbox - select multiple values from clipboard (SAP,Excel,..)

johnw — Sat, 21 May 2016 00:15:24 GMT

So in this example you'd have cut values 400013, 140350, etc. into your clipboard from Excel? And you want to find any name that contains something from the list? It appears that when I paste that into a variable, I get two spaces after each value. So paste it into a variable, trigger an action OnInput to clear the field then select in field, and write an expression that turns what you pasted into a wildmatch:

='=wildmatch(Name,'&chr(39)&'*'&replace(trim(List),' ','*'&chr(39)&','&chr(39)&'*')&'*'&chr(39)&')'