Skip to main content Skip to complementary content

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.


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 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.

Learn more


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 – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: