Blog

Set Operators in Qlikview

19 September, 2018

Related Blogs

Set Operators in Qlikview

There are several set operators that can be used in set expressions. All set operators use sets as operands and return a set as result. + (Union): This binary operation returns a set consisting of the records that belong to any of the two set operands. – (Exclusion): This binary operation returns a set of the records that belong to the first but not the other of the two set operands. Also, when used as a unary operator, it returns the complement set. * (Intersection): This binary operation returns a set consisting of the records that belong to both of the two set operands. / (Symmetric difference): This binary operation returns a set consisting of the records that belong to either, but not both of the two set operands. The order of precedence is:
  • Unary minus (complement)
  • Intersection and Symmetric difference
  • Union and Exclusion
Within a group, the expression is evaluated from left to right. Alternative orders can be defined by standard brackets, which may be necessary because the set operators do not commute. For example, A+(B-C) is different from (A+B)-C which in turn is different from (A-C)+B.