QlikView supports text search in a field. A search's result often includes all values that contain a specified string.
As opposed to above search, for a "perfet match" a field’s value should be displayed if only this value is an "exact match" to entered searched string.
To achieve a “perfect match" you need to enter a string surrounded by a single quote (See attached sample).Exemple
: as you type in your search string, the result will be displayed only if
there is a match in field values.
You should always be allowed to write for exemple =Fieldname='this value'
as a search expression in a list box.Note:
1. The use of equal sign
and single quote
in the search
2. This is possible if your list box is based on a normal field (e.g. myProduct, myName) not on an expression.