Discussion Board for collaboration on QlikView Scripting.
This is my sql query in qlikview script.
type in (1,2,5)
Now I don't want type to contain (1,2,5).
I want it to come from a variable.
how do i define the variable, and how do I change the query where expression.
SET vList = 1,2,5;
type in ($(vList));
Try like below:
LET vTypes = '(1,2,5)' ;
SQL SELECT CODE,
WHERE TYPE IN $(vTypes) ;