8 Replies Latest reply: Mar 30, 2017 11:52 PM by Rahul Pawar RSS

    Count based on 2 text field values

    Micahel Comens

      Hello, I am new to Qlik and not the best at writing expressions, I have searched the discussions to find an answer to how I can write expression to count  city based on a "yes" in a separate text field.  I have found and tried many options but cannot seem to get the count.

       

      Below is example.

       

      CityAttended
      PONYES
      PON

      CHI

      YES
      CHI
      PONYES

       

      I want to count PON when "Attended"="YES" so CHI should be ignored and null values should also be ignored.

       

      The answer that I would expect in the above example is 2 however I cannot seem to write the expression.

       

      Any help would be appreciated.

       

      Mike