Set Analysis is extremely powerful, however it can seem a bit overwhelming at times. One thing I felt helped we further understand the mechanics is recognizing what will work within a filter search, will work within a Set Analysis condition between double quotes.

For example, take this dataset:

Using advanced search functionality, you can filter down the data based on an expression:

Apply the same expression in Set Analysis and you will receive the same filtering capability:

Expression: =Sum({<id={“=Sum(exp)>50”}>} exp)

You can not only use expressions, but take advantage of the other search features, such as the ? wildcard. In this example, ???? would filter the name down to values with 4 characters.

Expression: =Sum({<name={“????”}>} exp)

You can think of Set Analysis as a where clause for an expression or a set of hard coded filters. Here is a cheat sheet, credit to ArturoMuñoz, which will provide some insight into the things you can do:

Lastly, there are some crazy things you can do using Dollar-sign expansion as well. Although I won’t go into in this post, it’s worth noting that Qlik’s semi-recent feature, the Dollar-sign expansion preview, has made it much much easier to implement these types of expressions.