2 Replies Latest reply: Mar 4, 2015 2:55 AM by jagan mohan rao appala RSS

    How can I do an 'And' selection on this data in QlikView?

    Joe Crane

      I did distinct(CustomerID) for a count of individuals that registered for AM 2012, 2013 and 2014.... but I want to find out who went to ALL three of the meetings, 2012 and 2013 and 2014, instead of just giving me the number of individuals that went to said meetings (or statement):

       

      Untitled.png

       

      When I run a nested select statement sql query of:

       

      select count(distinct CustomerID)

      from EventList

      where eventtitle  = 'Annual Meeting 2012'

      and CustomerID in

      (select distinct CustomerID

      from EventList

      where eventtitle = 'Annual Meeting 2013'

      and CustomerID in

      (select distinct CustomerID

      from EventList

      where eventtitle = 'Annual Meeting 2014'));

       

      I get 288 distinct individuals that went to ALL THREE events. Does this make sense? If so how would I accomplish this?

       

      Thanks,

       

      Joe