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';
WHERE LastName NOT IN '$(vList)'
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);
View solution in original post
Yes it is possible
Thanks, didn't know I have to removed the single quotes in the SQL.
Mine is now working.