3 Replies Latest reply: Jun 29, 2017 1:38 PM by Celia Seward RSS

    count distinct if something is true

    Celia Seward

      each of my data records includes these fields:

       

      studentid

      consult_time

      direct_time

      referral_time

      eval_time

      other_time

      indirect_time

      individual_time

      date

       

      I want to count the distinct studentid    if (consult_time+individual_time+direct_time) >0

      So, I'm trying to create a measure that will return a number based on the above formula.

       

      Any ideas?  I'm new to Qlik Sense.

       

      Celia