4 Replies Latest reply: May 4, 2017 4:53 AM by Luis Carmona Martínez RSS

    Intersection Operator * Qlik Sense

    Luis Carmona Martínez

      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:

      OperatorDescription
      +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!!