What is the difference between Search , Fuzzy Search and Advance Search ??

[nikhilgarg]

Hey,

Can anyone tell me what is the difference between

Search , Fuzzy Search and Advance Search ??

Thanks

[#2]

Fuzzy search:

Fuzzy search is similar to standard search, with the exception that it compares and sorts all field values according to their degree of resemblance to the search string. Fuzzy search is especially useful in situations where misspelling is an issue. It can also help you find multiple values that are nearly identical to each other.

When a fuzzy search is made, a tilde-character (~) is displayed in front of the search string.

Advanced Search:

If you start your text search with an equal sign = , you may enter an advanced search expression involving search criteria for associated fields and full boolean logic. After the equal sign you may type any valid QlikView layout expression, see Chart Expressions. The expression will be evaluated for each filed value in the search field. All values for which the search expression returns a non-zero value will be selected.

[#3]

Hi,

check this link

What is the main diff. b/w normal,wildcard and fuzzy search?

[nikhilgarg]

Hey,

Thanks , but can you please tell me by an example for fuzzy search and Advanced Search ??

[nikhilgarg]

Hey,

Thanks , but can you please tell me by an example for fuzzy search and Advanced Search ??

[jagan · Accepted solution]

Hi,

Suppose you have a country field like below

QVDTable:

LOAD

*

INLINE [

Country, Sales

China, 100

Cambodia, 200

Croatia, 300

India, 400

Indonesia, 200

USA, 350

UK, 300];

Fuzzy Search: When you use this search and A in Country list box then all the values which has character with A is moved to the top of the list, the best matched values are moved to the top of the list, while other values are displayed below.

Advanced Search: Supposed if you want to select by using some expression then you can use Advanced search.  For example if you give

=Sum(Sales) > 300

then India and USA is selected, since it has sales > 300.

Hope it helps you.

Regards,

Jagan.

[nikhilgarg]

HEy,

You mean to say that :

In Advanced Search we can search with help of an expression. Right ??

And

What would be the difference between Fuzzy Search and Search ??

[jagan]

Hi,

Yes, with Advanced search you can filter values by using expression.

Difference between Fuzzy Search and Search is, in search unmatched records are hidden and only matched records are shown, where as in Fuzzy Search matched records are displayed on top (first).

Regards,

Jagan.

[nikhilgarg]

HEy,

U mean to say :

The ONLY Difference between Search and Fuzzy Search is that in search all unmatched records are not shown but in Fuzzy Search unmatched records are shown but at botom.

Is it so ??

[jagan]

Yes.  You can try practically and found the difference.

Regards,

Jagan.