2 Replies Latest reply: Oct 26, 2013 9:13 AM by KOUENS HUGUES RSS

    SQL in QLIKVIEW

      hello
        I need help, I want to know if it is possible to execute the kind of Requette in QlikView


       

      SQL SELECT *

      FROM users  WHERE (idpropriete='3')  AND ( name NOT LIKE ('%VISISTEUR%') )  ; 

       

      OR

       

      SQL SELECT *

      FROM users   WHERE (idpropriete='3')  AND (name NOT IN (SELECT name FROM users  WHERE name LIKE ('%VISISTEUR%') )  );