topic Search Object Functionality in QlikView

Search Object Functionality

Fri, 04 Nov 2011 17:41:15 GMT

Hello,

When using the search object I find that the more information I enter the more results I get, which seems wrong. With a more specific entry shouldn't I get a smaller subset of results? Can anyone suggest how I could configure the search box to narrow its search given multiple word entrys, or just explain its functionality.

Thanks,

Tyler

Re: Search Object Functionality

Fri, 04 Nov 2011 17:46:19 GMT

It seems like the normal search will search for every word typed like as if it had 'or' between each word. If you use wild match search * * it will search for exact string.

So Need Sample will return anything containing Need or Sample.

*Need Sample* returns only results containing the string 'Need Sample'

I have not used the other search options, so I am not aware of how they work.

Edit: The help section has a lot of information regarding how the search works. If you look at the help section for 'Fuzzy Search' there is a link to Search that describes the normal function.

Search Object Functionality

Fri, 04 Nov 2011 17:51:20 GMT

Does anyone know of a way to get the 'AND' functionality, instead of the 'OR' that marcsliving has described?

Search Object Functionality

Fri, 04 Nov 2011 17:59:15 GMT

Add a * to the end of the string you are typing. This will only bring back results that start with what you typed

Search Object Functionality

Fri, 04 Nov 2011 18:04:43 GMT

I dont beleive the '*' is what I am looking for. Here is an example that may help clarify:

Lets say I had this list:

"swiss cheese"

"cheddar cheese"

"provolone cheese"

"pepper jack cheese"

When I search "cheese swiss" I would only want the "swiss cheese" result to appear but as of now I see all the cheeses. I am looking for a way to get the keywords to narrow down the result instead of increasing it.

Search Object Functionality

rrsrini2907 — Fri, 04 Nov 2011 18:46:11 GMT

Hi,

By default Qlikview uses some algorithm.

But you can change it based on your requirement.

The fuzzy search can help in your case. It will show all values but when you enter "Cheese S" and hit enter, it will select "swiss cheese" is selected.

Regards,

Srini.