topic Re: SQL in QLIKVIEW in QlikView

SQL in QLIKVIEW

Sat, 26 Oct 2013 13:02:46 GMT

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

SQL SELECT *

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

swuehl — Sat, 26 Oct 2013 13:07:29 GMT

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

Sat, 26 Oct 2013 13:13:24 GMT

OK thank