Use Qlik Variable in IN clause in SQL

[Lesor]

Hi,

Is it possible to use the variable in Qlik in SQL?

In my sample below, the result is that the output still includes Name1 .

SET vList = 'Name1' , 'Name2';

LOAD

FirstName, LastName

;

SQL

SELECT 

FirstName, LastName

FROM Table1

WHERE LastName NOT IN '$(vList)'

;

[Gabbar]

Yes it is possible

[marcus_sommer · Accepted solution]

The variable vList contains already the string-wrapping quotes and therefore the call of the variable doesn't have them, means the where should like:

WHERE LastName NOT IN $(vList);

[Lesor]

Thanks, didn't know I have to removed the single quotes in the SQL.

Mine is now working.