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. The expression will be evaluated for each filed value in the search field. All values for which the search expression returns a non-zero value will be selected.
Examples:
| Example | Description |
|---|---|
| =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. |
