Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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.