topic Script Variable at SQL query in QlikView

Script Variable at SQL query

Sun, 22 Dec 2013 08:20:59 GMT

Hi.

This is my sql query in qlikview script.

Select

code,

type

From

table

Where

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.

Thank You.

Re: Script Variable at SQL query

Gysbert_Wassenaar — Sun, 22 Dec 2013 10:50:50 GMT

Like this:

SET vList = 1,2,5;

Select

code,

type

From

table

Where

type in ($(vList));

Re: Script Variable at SQL query

Mon, 23 Dec 2013 19:28:01 GMT

Try like below:

LET vTypes = '(1,2,5)' ;

TYPE:

SQL SELECT CODE,

TYPE

FROM TABLE_NAME

WHERE TYPE IN $(vTypes) ;