3 Replies Latest reply: Apr 21, 2017 10:20 AM by qiao hua RSS

    QlikSense Sumif function

      Hi new to qliksense and I am trying to add the values in one column based on the flag in another.

       

      AB

      1

      1
      01
      10
      10
      11
      01

       

       

      I want to add up column B based on what is in Column A. I want to Sum all values in together in B where they have a value 1 in column A.

       

      in this scenario the sum should be 2.