Skip to main content

Set modifiers with advanced searches

Advanced searches using wild cards and aggregations can be used to define sets.

Examples:  

Examples and results
Example Result
sum( {$–1<Product = {“*Internal*”, “*Domestic*”}>} Sales )

Returns the sales for current selection, excluding transactions pertaining to products with the string ‘Internal’ or ‘Domestic’ in the product name.

sum( {$<Customer = {“=Sum({1<Year = {2007}>} Sales ) > 1000000”}>} Sales )

Returns the sales for current selection, but with a new selection in the 'Customer' field: only customers who during 2007 had a total sales of more than 1000000.

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: ampquestions@qlik.com