Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What are the Types of Search in qlikview and explain with Example?
Thanks in Advance
Very detailed explanation is provided in Qlikview help.
i want some of the example about the search types?
search types:
1.Normal Search
2.Fuzzy Search
3.Associative Search
See Following blog by HIC:
and this thread also helpful for you
What is the difference between Search , Fuzzy Search and Advance Search ??
Take a look into this,
from QV Reference Manual,
12.3 Search
Selections can be made through text search as well. To enter
a search string, click on the list box header, then simply type
the search string. The string is not case sensitive. The search
string will appear in the pop-up search box. As a result, QlikView will display all the
values of the selected field that fulfill the criteria of the search string. When you press
ENTER, or click on one of the cells in the result, the value(s) become(s) selected. By
keeping the CTRL key depressed while pressing ENTER the selections from the text
search will be added to previous selections.
The search box will close automatically when you hit ENTER, ESC or click in the layout.
You may also close it by clicking the icon in the search box. The search box is
sizable and will retain its size when it is opened again.
LOGIC AND SELECTIONS
131
III
If several list boxes are active (SHIFT-click on their headers to make them active),
they are all included in the text search. Pressing ENTER to select the resulting values is
however not possible until there are optional values in only one of the active list
boxes.
If a selection has already been made, there are two ways in which a search can be
interpreted: either you search only among the optional values, or you search among
all values, i.e. you include the excluded values in the search. To set the search mode
to work in, you can either select or deselect Include Excluded Values in Search in
the User Preferences dialog. This mode can also be set on certain individual sheet
objects.
If the logical and option is set for a field, it may not be possible to select multiple values
found.
Text Search
The simplest way of searching is text search. QlikView will search for field
values matching a text string that you type. If no wildcards are used (Normal
Search), QlikView will look for words that begin in the same way as the
search string. If the search string contains several words separated by blanks,
QlikView will interpret it as several search strings and display field values
that contain either of the strings.
The Search string may however contain wildcard characters (Wildcard
Search). If wildcards are used, only those records that match the entire
search string will be displayed, that is a blank does not imply a logical OR.
Wildcards may appear several times in the search string, regardless of their
location. The following wildcards can be used:
* Zero or more characters.
? Any single character.
^ whole string.
The ENTER key can be pressed to select the values found, and the ESC key
can be pressed to cancel the operation.
Examples:
a* will find all values that begin with the letter a.
*b* will find all values that contain the letter b.
Fuzzy Search
If you start your text search with a tilde sign ~ the text search window will be
opened in fuzzy search mode. The search window will contain the tilde with
the cursor placed after it. As you type all values will be sorted by the degree
132
of resemblance to the search string with the best matches at the top of the
list. If you hit ENTER the first value in the list will be selected.
Numeric Search
Selections can be made through numeric search as well. This is very similar
to text search. The only difference is that the search string must begin with
one of the relational operators ">", ">=", "<" or "<=".
Examples:
>900 will find all values greater than 900.
<=900 will find all values less than or equal to 900.
>900<1000 will find all values greater than 900 and less than 1000.
<900>1000 will find all values less than 900 or greater than 1000.
Initial Search Mode
When you start typing text, the behavior may differ: in some cases,
QlikView add wildcards (to facilitate a Wildcard Search) or a tilde (for
Fuzzy Search) to the search string; in some cases QlikView will not add any
characters at all (for Normal Search) to the search string.
The preferred search mode can be set in the object properties and in User
Preferences.
Search String Evaluation
After a search string has been entered or edited, QlikView evaluates which
one of the above described search behaviors to select.
If the search string contains wildcard characters, a Wildcard Search will be
made. If the search string begins with a tilde, a Fuzzy Search will be made.
If the search string contains neither wildcard characters, nor a leading tilde, a
Normal Search will be made.
It is always possible to change the search mode simply by deleting or adding
wild cards, a tilde (~), a greater than (>) or smaller than (<) symbol in the
search string.
Associated Search
The search box contains a chevron to the right. If this is clicked, the search
box is expanded to the right and a secondary result set is displayed next to
the primary result set. This secondary list contains search matches in other
fields. It is now possible to click in the secondary result set and make temporary
selections. Such selections will narrow down the result in the primary
result set. Once a selection in the secondary list has been made, it is possible
to enter a new search string before making the selection in the primary list.
LOGIC AND SELECTIONS
133
III
Finally, when a selection is made in the primary result set, the secondary
result list is closed.
Advanced Search
For complex search expressions you can use the Advanced Search dialog
(see below), which can be invoked by the keyboard shortcut CTRL+SHIFT+F.
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 chapter 15 in Book III). The expression will be evaluated for
each field value in the search field. All values for which the search expression
returns a non-zero value will be selected.
Examples:
=MyField like 'A*' or MyField like '*Z'
if e.g. invoked from a list box containing the field
MyField, the search would return all field values
either starting with the letter A or ending with the
letter Z.
=sum(Sales)>sum(Budget)
if e.g. invoked from a list box containing the field
Salesman, the search would return all salesmen
with an associated sales value larger than their
associated Budget.
Close the thread if you got the answer.