Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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
Partner
Partner

Re: Using Variable in Load Script WHERE clause

Try:

WHERE APP_FLAG = '$(vAPPFlag)'

View solution in original post

3 Replies
Partner
Partner

Re: Using Variable in Load Script WHERE clause

Try:

WHERE APP_FLAG = '$(vAPPFlag)'

View solution in original post

danielrogra
Contributor

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!