Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

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 ? multiple value selection.jpg

Best regards, Kazi

2 Replies
Highlighted

Look at this thread by @swuehl

Compound Search - demystified

Highlighted
MVP & Luminary
MVP & Luminary

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:

ExcelListboxSearchString.JPG

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