13 Replies Latest reply: Mar 6, 2015 6:03 AM by Sofiene Khayati RSS

    QlikViews equivalent to NOT IN?

      Hello,

       

      I am trying to create a not in query of a resident table. In SQL the statement would be something like:

       

      SELECT * FROM (SELECT * from table_1 where x = 'y' and z = 'x') t

      WHERE id NOT IN (SELECT id from table_1 as t2 where t2.x = 'yy' and z = 'xx')

       

      Can anyone help me?

       

      Thanks,

       

      James Ford