What does the unary operator "-" return in Qlik Sense?

The unary operator "-" in Qlik Sense is used to denote the complement set of the given operand. This function is essential in set analysis, allowing you to exclude specific data from your analysis. When you apply the unary operator to a specific set of records, it essentially returns all the records that are not included in that set. This is a powerful tool for creating filtered views of your data and helps in performing in-depth analysis by focusing on the data that is not part of a particular set.

In set analysis, being able to define a complement is valuable because it allows for comparative analysis against the excluded items, helping to clarify insights into what exists outside of a specified context. This operator can simplify complex queries by making it easier to represent exclusions without the need for additional logic to filter out unwanted records.

Understanding this operator and its output is crucial for building effective data models and analyses in Qlik Sense.