Hi. I am using Qlik Sense 3.1 and I am not finding a solution for the Intersection of two sets.
I just need to get the SUM of Sales of Costumers who have bought Product A and also bought Product B. Although the sales of product A and B will not be on the same row of the data file.
Is that feasable? I have been able to use the "+" operator, that shows the ones that have bought Product A or B. But I need to use the "*" operator to just narrow it.
Arguments:
| Operator | Description |
|---|
| + | 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 (XOR). This binary operation returns a set consisting of the records that belong to either, but not both of the two set operands. |
Are all set operator working in Sense as in QView?
Formula with the Problem:
Result Obtained: 0
Sum(
{<
Article_Set={"ProductA*"}
>*<
Article_Set={"ProductB*"}
>}
[Sales])
Please Help!!
