4 Replies Latest reply: Jul 18, 2017 1:58 PM by Michael Solomovich RSS

    Sum of values that follow some rules

    Caio Lobato

      Hello,

       

      I have a problem here and I am wondering how to make this works on Qlik Sense.

       

      So, I have this table here to use as example.

       

      Col1ProductCol3Col4
      xa20
      xb3#
      ya7#
      yc8#

       

      What I need from this data is the sum of Col3 where Product has Col1 = 'X' AND 'Y' (Both).

      Also this sum of Col3 have to consider just rows where Col4 = '#'.


      So the result on this example will be '7'. Since only Product 'A' has the requirements and the 1st row is not Col4 = '#'.