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

    QlikViews equivalent to NOT IN?



      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?




      James Ford