topic Re: Can QV use variables in [SQL SELECT] ? in QlikView

Can QV use variables in [SQL SELECT] ?

mokitsu61 — Sun, 17 Jun 2018 23:59:20 GMT

Hi,

Can QV use variables in [SQL SELECT]?

e.g.

SET vCondition = '';

SQL SELECT *

FROM TableName

WHERE A = $(vCondition);

Re: Can QV use variables in [SQL SELECT] ?

mayankraoka — Mon, 18 Jun 2018 01:55:33 GMT

You can also use below:

Let vCondition = '';

SQL SELECT *

FROM TableName

WHERE A = '$(vCondition)'

Regards,

Mayank

Re: Can QV use variables in [SQL SELECT] ?

brooksc57 — Fri, 03 Dec 2021 17:41:02 GMT

you wouldn't believe how hard this was to find. I kept searching preceding load with sql select variable and similar things to that...thanks so much for your post. it will greatly reduce the punishment of returning too many useless records!!!