# Advanced Search

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:

Advanced Search examples

| Example | Description |
| --- | --- |
| =MyField like 'A\*' or MyField like '\*Z' | if e.g. invoked from a list box containing the field MyField, the search<br>would return all field values either starting with the letter A or ending<br>with the letter Z. |
| =sum(Sales)&gt;sum(Budget) | if e.g. invoked from a list box containing the field Salesman, the search<br>would return all salesmen with an associated sales value larger than their<br>associated Budget. |

## Learn more

* [Chart expressions](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/ChartFunctions/chart-expressions.htm)