As you type your search string, Qlik Sense filters the field values and displays the matching items. If you perform a normal search (without wildcards), strings that match the search string are displayed. If you use several strings, separated by blanks, each of these is interpreted as a separate search string and displays all field values that contain either of the strings. If you want the separate search strings to be interpreted as only one string, use quotation marks (" ") to link the strings together. You can also use a plus sign (+) for a similar result. By using a plus sign, you set the condition that strings with a plus sign must be included in the matching items. However, the strings need not necessarily be next to each other, nor in the same order as they were entered.
Information noteSearch is not case sensitive.
Example
Result
"orange juice"
Only finds field values that contain the whole string 'orange juice'.
orange juice
Without the quotation marks, all fields that contain either 'orange' or 'juice' would be displayed.
+orange +juice
Finds matches such as 'orange juice', 'orange and apple juice' and 'juice from oranges'
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 misspelt, when you are unsure of the spelling, or when the string contains special characters that may be difficult to reproduce correctly.
Information noteIf 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.
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'
Information noteSpace 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'.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
