Mastering Qlik Sense

Set modifiers with advanced searches

Sets can also be defined by using wildcards (*) or complex aggregations.

I showed the use of wildcards in the previous section. We can, for example, show the sales of all the products starting with the letter S:

sum({$< [Product Description] = {"S*"} >} Sales)

The wildcard * can be used anywhere in the string, and it is a replacement of any character or string of any length. The preceding example can return Shoes, Shirts, or any other string starting with S.

Within our set modifiers, we can use complex aggregations. For example, we may want to know the sales of those who sold more than two products in the year 2018:

sum({$< [Sales Manager] = {"=count({1<Year = {2018}>} distinct [Product Id]) > 2" } >} ...