Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hlines_usacs
Contributor II

Using Variable in Load Script WHERE clause

Hello, hopefully this is an easy one. I just can't figure out the correct syntax. Below are two screen shots; the first one loads without error, but the second does not. Does anyone know the correct syntax for using this variable to filter data?

Run successfully:

load script 1.jpg

Throws error:

load script 2.jpg

1 Solution

Accepted Solutions
shivanandk
Contributor II

Re: Using Variable in Load Script WHERE clause

Try:

WHERE APP_FLAG = '$(vAPPFlag)'

3 Replies
shivanandk
Contributor II

Re: Using Variable in Load Script WHERE clause

Try:

WHERE APP_FLAG = '$(vAPPFlag)'

danielrogra
New Contributor III

Re: Using Variable in Load Script WHERE clause

Hi Hannah

Have you tried using '$(vAPPFlag)'?

Regards

hlines_usacs
Contributor II

Re: Using Variable in Load Script WHERE clause

perfect! thanks so much!

Community Browser