8 Replies Latest reply: Oct 28, 2015 5:28 AM by Mayank Raoka RSS

    Qlikview Count Distinct, with and IF OR satement

      I want to count the distinct drivers that start an account job OR complete a street job. I know to count the distinct drivers (using set analysis) who start an account job is: 

      count(DISTINCT

      {$ 

      <_account_jobs_started={1}>

      }

      driverId)

      and to count the number of drivers who do a street job is

      count(DISTINCT

      {$ 

      <_street_job={1}>

      }

      driverId)

       

      But how do I do this as an OR statement if I do:

      count(DISTINCT

      {$ 

      <_street_job={1},_account_jobs_started={1}>

      }

      driverId)

      This will make it an IF AND statement.

       

      How do I do an IF OR count. Your help would be much appreciated.