Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%') ) );
In general, QV will pass the SQL statement to the DBMS driver, so if your DBMS understands the SQL syntax, this should work.
OK thank