Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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!!