Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
agsearle
Creator
Creator

Multiple search of list box

A nice simple one for you experts.

I have a table box with thousands of rows of data. I also have a list box showing the account numbers from the table box.

All I want to do is to paste into the search facility of the list box a series of account numbers. It only allows me to paste one at a time which is no good to me (ie the first number in the copied account numbers)

Is there any way I can do this?

4 Replies
sathishkumar_go
Partner - Specialist
Partner - Specialist

Hi Andrew,

Which version u r using? In qlikview 9 have search object is there.

u can use that then ur problem ll be solved

-Sathish

agsearle
Creator
Creator
Author

Sorry using V9.

I've tried the search object, but it only seems to allow me to search for one account at a time? I need to paste and range of accounts into it. Is this possible?

agsearle
Creator
Creator
Author

Sorry to bump, but I really need a solution for this one, does anyone have any ideas?

johnw
Champion III
Champion III

I don't think this helps, but in case it's part of a solution, you can type something like this when doing a search:

=match(Customer,'Ann','Bob')

And it will show both Ann and Bob. Maybe there's some easy way to convert your copied list into that sort of search string that I'm not thinking of.