This is where the users were confused. Is something wrong? What’s going on in table #2?
Answer: Exactly what is supposed to be going on—this is how set analysis works. The “=” (equal sign) in the expression:
[Animal] = {“Dog”,”Fish”,”Turtle”}
means, “only values of [Animal] that are Dog or Fish or Turtle, no matter what values are filtered.” In other words, using only the equal sign overrides the filter criteria with only the values in the set analysis expression.
Most of the time, this is exactly what we want it to do, however, in many cases we actually do want to consider both the filters and set analysis. This is exactly what those users wanted to happen and it’s what confused them.
Fortunately, Qlik provides a solution for this.
Back to those operators += *= -= /= that I mentioned earlier. These are what we use when we also want to consider the filtered values.
Stand back, because we’re about to put the “Set” in “Set Analysis”—and YES—there will be Venn diagrams.
This is the best article that explains logical operations of set analysis in Qlik. Thank you, Leslie.
Thanks! I’m so glad this was helpful.
merci !!!!!!! tout est clair pour moi maintenant