• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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.

Summary
Review Date
Reviewed Item
Set Operators in Qlikview
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Set Operators in Qlikview"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.