topic Re: Use a variable in sql select in QlikView

Use a variable in sql select

Tue, 13 Oct 2015 17:41:43 GMT

I set a variable at the beginning of my script, and I would like to assign this variable to every row of data in my sql select statement.

The variable is called vTmp and this is how I am trying to incorporate it but it is not working.

LOAN:

SQL SELECT

"Account_Phone",

"Account_Type",

"Risk_Raiting",

$(vTmp)

FROM "database".dbo."table";

Is this technique possible?

Thanks

Re: Use a variable in sql select

maxgro — Tue, 13 Oct 2015 17:48:41 GMT

maybe

'$(vTmp)'

what's your variable?

Re: Use a variable in sql select

Anonymous — Tue, 13 Oct 2015 17:50:17 GMT

You may need to use Preceding Load something like this :

LOAN:

Load

*

$(vTmp)

;

SQL SELECT

"Account_Phone",

"Account_Type",

"Risk_Raiting",

$(vTmp)

FROM "database".dbo."table";

Re: Use a variable in sql select

Clever_Anjos — Tue, 13 Oct 2015 18:12:47 GMT

It´s possible, what is the content of your variable?