Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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%') )  );

2 Replies
swuehl
MVP
MVP

In general, QV will pass the SQL statement to the DBMS driver, so if your DBMS understands the SQL syntax, this should work.

Not applicable
Author

OK thank