topic Re: What is the difference between Search , Fuzzy Search and Advance Search ?? in QlikView

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

nikhilgarg — Wed, 29 Oct 2014 07:23:01 GMT

Hey,

Can anyone tell me what is the difference between

Search , Fuzzy Search and Advance Search ??

Thanks

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

Wed, 29 Oct 2014 07:26:52 GMT

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.

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

Wed, 29 Oct 2014 07:27:43 GMT

Hi,

check this link

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

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

nikhilgarg — Wed, 29 Oct 2014 07:35:23 GMT

Hey,

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

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

nikhilgarg — Wed, 29 Oct 2014 07:35:36 GMT

Hey,

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

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

jagan — Wed, 29 Oct 2014 07:56:43 GMT

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.

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

nikhilgarg — Wed, 29 Oct 2014 08:58:12 GMT

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 ??

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

jagan — Wed, 29 Oct 2014 09:09:06 GMT

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.

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

nikhilgarg — Wed, 29 Oct 2014 09:15:51 GMT

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 ??

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

jagan — Wed, 29 Oct 2014 09:22:53 GMT

Yes. You can try practically and found the difference.

Regards,

Jagan.

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

nikhilgarg — Wed, 29 Oct 2014 09:29:27 GMT

Hey ,

Thanks jagan. One more question.

I want to see how macros work in qlikview. What impact they do on qlikview. But i dont know to create macros. So can you please tell me an example of macro and its working so that i can implement it in my example and can see the result.

Thanks

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

jagan — Thu, 30 Oct 2014 01:52:30 GMT

Hi Nikhil,

Check this thread there are lot of sample macros available.

Useful Qlikview Macros

Hope this helps you.

Regards,

Jagan.

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

jagan — Thu, 30 Oct 2014 01:53:13 GMT

Hi,

Please close this thread by giving Correct and Useful Answers to the post which helps you in finding the solution, it helps others in finding the answers easily for similar scenarios.

Regards,

Jagan.

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

Sun, 09 Nov 2014 06:45:55 GMT

Hi jagan,

as u said if i go with fuzzy search and typed letter 'a' but uk is in middle the words containing a is in down why?