Search

As an alternative to making selections by clicking values in QlikView objects, you can make selections through text or numeric search.

Making Selections Using Search

The following section describes how to make selections using text search, and how QlikView responds to different commands. Perform the following steps:

  1. Click on the list box caption, and type the search string. The string is not case sensitive.

    The search string appears 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.

  1. Press Enter or click one of the cells in the result to select that value. 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 press Enter or Esc, or when you click in the layout. You can also close the search box by clicking the x-icon in the search box. The search box is sizable and will retain its size when it is opened again.

Search in Multiple List Boxes

All active list boxes will be included in the search. To search in multiple list boxes, Shift-click on their captions to make them active. It will not be possible to press Enter to select the resulting values as long as there are optional values in several of the active list boxes.

If a selection has already been made, there are two ways in which a search can be interpreted:

  • Search only among the optional values
  • Search among all values, i.e. including the excluded values in the search

To set the search mode to work in, it is possible to 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.

Note: 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.

In normal search (no wildcards are used), 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.

Wildcards

You can use one or several wildcards in a search string. The following wildcards can be used:

Wildcard Representation
* Zero or more characters, including blank. This wildcard is flexible and matches any character or any block of characters in a specific position.
? A single character, including blank. This wildcard is useful when you suspect that a string may be misspelled, when you are unsure of the spelling, or when the string contains special characters that may be difficult to reproduce correctly.
^ Beginning of word within field value. This wildcard is used in conjunction with other wildcards.
Note: If you use wildcards, only those records that match the entire search string are displayed, that is, a blank does not imply a logical OR. The search string '*creamed' does not get a match on "Rocky's creamed corn" since the value does not end with “creamed”. Neither does “creamed*” result in a match on "Rocky's creamed corn", since the value does not start with “creamed”.
Example Result
a* Finds all values that begin with the letter “a”, including strings with several words where the first word begins with an “a”.
*b Finds all values that end with the letter “b”, including strings with several words where the last word ends with a “b”.
*c* Finds all values that contain the letter “c”, including strings with several words
*^ab*

Returns all values that have words that begin with “ab”.

Equivalent to a normal search for “ab”, but unlike the normal search it can be made more complex using wildcards. It can also be used in a programmatic search, such as in Set Analysis.

r?ck Finds all values that have four letters and start with an “r”, followed by any character, and ending with “ck”, for example, “rack”, “rick”, “rock”, and “ruck”.
r?? ????d Finds all values that consist of a three-letter word beginning with an “r” and a five-letter word ending with a “d”.
Note: Space in a search string makes a difference. If you search for “*corn” you get matches on strings ending with, for example, “popcorn” as well as “corn”. If you use a space in your search string, “* corn”, you only get matches that end with “corn”.

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.

If starting a text search with a tilde-character, the text search window will open 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 of resemblance to the search string with the best matches at the top of the list. If you press Enter, the first value in the list will be selected.

Numeric Search

You can make selections using 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 following relational operators:

Operator Description
> greater than
>= greater than or equal
< less than
<= less than or equal

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 starting to type text, the behavior may differ: in some cases, QlikView adds wildcards to the search string, to facilitate a wildcard search.

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 instead of normal search.

It is always possible to change the search mode simply by deleting or adding wild cards, a greater than (>) or smaller than (<) symbol in the search string.

Associative Search

The list box's search box contains a chevron (>>) to the right. If you click it, 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 you make a selection in the secondary list, you can enter a new search string before making the selection in the primary list. Finally, when you make a selection in the primary result set, the secondary result list is closed.

Advanced Search

For complex search expressions it is possible to use the Advanced Search dialog, 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 can type any valid QlikView layout expression (Edit Expression Dialog). 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.

Example:  

=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.

Example:  

=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.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?