topic List in a Search Object in QlikView

List in a Search Object

Mon, 26 Sep 2011 13:47:19 GMT

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

List in a Search Object

Anonymous — Mon, 26 Sep 2011 13:51:18 GMT

Enter 25 and a SPACE ?

List in a Search Object

Mon, 26 Sep 2011 13:53:31 GMT

Unfortunately, it doesn't work.

List in a Search Object

Mon, 26 Sep 2011 14:07:02 GMT

try

25 OR 675 OR 9832

with search mode "normal"

List in a Search Object

Anonymous — Mon, 26 Sep 2011 14:12:23 GMT

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." ......

List in a Search Object

Mon, 26 Sep 2011 14:17:06 GMT

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 ?

List in a Search Object

Mon, 26 Sep 2011 15:44:45 GMT

hi lionel,

do you really need this in the search object ?

What about setting a bookmark with your predefined customers ?

hope this helps

Gilles

Re: List in a Search Object

jedgson — Mon, 26 Sep 2011 15:49:30 GMT

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

List in a Search Object

Mon, 26 Sep 2011 16:01:45 GMT

Use Advanced Search and write expression as require like

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

or you can use wildmatch

Hope this will help!

Dinesh

List in a Search Object

Mon, 26 Sep 2011 16:33:49 GMT

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

Lionel

Re: List in a Search Object

Anonymous — Thu, 26 Sep 2013 00:42:55 GMT

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.