7 Replies Latest reply: Jun 1, 2011 7:31 AM by Andy McCallum RSS

    Excluding data in set analysis

      I need to count the Customers (CON_CUSTOMER) where there are no matches for SME_Person 
      and LinkContact.  I have written the following set analysis but Qlikview is picking up both matches and non-matches
      count({$<CON_CUSTOMER = E({1<SME_Person = {LinkContact}>})>}CON_CUSTOMER)
      
      Can anyone shed any light on where I'm going wrong?