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

[Anonymous]

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

[berndjaegle]

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

[Kushal_Chawda]

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

[miguelbraga]

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,

MB

[tresesco]

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

[Anonymous]

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

[johnw]

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)&')'