mobileNavlogo
headerlogo

Set Operators in Qlikview

19 September, 2018

Ratings

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.

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .