By default, all calculations refer to the current selection state. In some specific situations, you may need to show data from a different selection. We can define a Set Analysis in calculations to help us modify the selection state for one or more fields.
Set Analysis is a unique feature in Qlik Sense. Each set contains a group of selected dimensional values. The sets allow the users to create independent selections, other than the one being used in the active Qlik Sense objects. The set expression is defined inside curly brackets ({}). The set identifiers are separated from the modifiers by angular brackets (< >).
A Set Analysis expression consists of three main parts:
- Set identifiers define the relationship between the set expression and the field values or the expression that is being evaluated. Some examples include...