List in a Search Object

[#1]

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

[Anonymous]

Enter 25 and a SPACE ?

[#3]

Unfortunately, it doesn't work.

[#4]

try

25 OR 675 OR 9832

with search mode "normal"

[Anonymous]

I tested it. You are right sorry about that.

Maybe somebody else has an answer for you I could not find a solution for it.

I could only think of a work-around.

You could add a caracter to your ID in your loading script, like a dot or something. like:

     ID & '.' as ID,

Not the best solution but that way you can search for "25." ......

[#6]

Thanks for your replies.

It tried the "25 OR 675" solution, but it doesn't work either.

I could indeed create an additionnal column filed with "ID" & "." (since ID is also a key field I have to keep the original value)...

Is there a more straigth forward way to do it ?

[#7]

hi lionel,

do you really need this in the search object ?

What about setting a bookmark with your predefined customers ?

hope this helps

Gilles

[jedgson]

You could create an input box and then use a macro to make a selection on the ID's table based on the list of values entered in the input box.

Jay

Edit - I am assuming that the list will always be different and entered by the user?  Otherwise it is easier to hard code the search as per other posts.

Message was edited by: Jay Edgson

[#9]

Use Advanced Search and write expression as require like

=match(Field,'20','25',.....)

or you can use wildmatch

Hope this will help!

Dinesh

[#10]

What do you mean by "Use Advanced Search" ? Is this a property of the Search Object ?

Lionel