Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List in a Search Object

Hi,

In a QlikView application, I would like to select an arbitrary list of customers, based on their IDs.

In order to do so I set up a Search Object where I enter a white space separated list of IDs (ex: 25 675 9832...).

My problem is that when I enter "25" I get all customers whose ID starts with 25 (250, 251, 252...) and not only customer ID=25. What can I do in order to get that ?

Thanks

Lionel

10 Replies
Anonymous
Not applicable
Author

No sure if it's too late but you can try this:

Create a listbox for this field, click on the magnifier icon to open the search dialog and type the following:

=Fieldname=25 OR Fieldname=675 OR Fieldname=9832

That should work.