topic How to search multiple values at a time from list box ? in QlikView

How to search multiple values at a time from list box ?

geam1988 — Tue, 22 Jan 2019 09:32:48 GMT

Hallo, I have a list box of multiple value, i want to copy multiple sales order number from excel file and paste in search option in List box. not interested to use CTRL and select value one by one. i want to select multiple value from list box at a time.

How to do that ?

Best regards, Kazi

Re: How to search multiple values at a time from list box ?

sunny_talwar — Tue, 22 Jan 2019 12:50:04 GMT

Look at this thread by @swuehl

Compound Search - demystified

Re: How to search multiple values at a time from list box ?

marcus_sommer — Tue, 22 Jan 2019 15:29:12 GMT

You need to create a single search-string from your values. For this you could use a variable within an inputbox which triggers a selection-action on your field with a search-string like: = '(' & replace('$(YourVariable)', ' ', '|') & ')' or you creates this search-string directly in excel, like in this example:

This copy & paste approach needs just a few seconds and the last value is then pasted into the listbox-search between the needed wrapping brackets, like:

(CTRL + V)

- Marcus