You can search for values and make selections from the resulting filtered list. You can search selection items in the selection bar, and within visualizations such as filter panes and tables. Search is not case sensitive.
Click a selection item, and in the selection pop-up, type your search string. The list is filtered as you type, to display matching values.
The result of searching for "Food" in the selection Product Group.
The result of search for "Mich" in the Manager filter pane.
For a PDF containing examples with versions in several languages, see Qlik Sense Cheat Sheet version 2.0.
Search types
Qlik Sense supports the following methods of searching in selections and visualizations:
| Search type | Description | Example | Supported data types in search field |
|---|---|---|---|
| Text search |
Use text, including quotation marks, wildcards, and modifiers (minus and plus). Text search is separated into two different search modes: normal search and wildcard search. For more information, see Text search. |
*company | Text string, numeric value, dual value |
| Numeric search | Relational symbols (">", ">=", "<" or "<=") allow values greater than, less than, and so on, to be found. For more information, see Numeric search. | >=5<20 | Numeric value, dual value |
| Fuzzy search | The tilde character ("~") as a prefix allows inexact matches to be found. For more information, see Fuzzy search. | ~beast company | Text string, numeric value, dual value |
| Expression search | An equals sign ("=") indicates an expression. Field values that match the expression are selected. For more information, see Expression search. | =sum(Sales)> 1000000 | Text string, numeric value, dual value |
| Compound search | Use search operators to combine multiple searches within a single line. For more information, see Compound search. | (*ABC* & ?*Inc*) | Text string, numeric value, dual value |