Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
stephenedberkg
Creator II
Creator II

Search Types

What are the Types of Search in qlikview and explain with Example?

Thanks in Advance

6 Replies
Not applicable

Very detailed explanation is provided in Qlikview help.

stephenedberkg
Creator II
Creator II
Author

i want some of the example about the search types?

search types:

   1.Normal Search

   2.Fuzzy Search

   3.Associative Search

jsingh71
Partner - Specialist
Partner - Specialist

See Following blog by HIC:

The Search String

and this thread also helpful for you

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

Not applicable

Take a look into this,

The Search String

buzzy996
Master II
Master II

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.

Not applicable

Close the thread if you got the answer.