Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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%') )  );

Tags (3)
2 Replies
MVP
MVP

Re: SQL in QLIKVIEW

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

Re: SQL in QLIKVIEW

OK thank

Community Browser