Set Operators in Qlikview
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.
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
About Author
Name
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 in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox