Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use ' in where clause of load

Hi,

I am trying to use below load statement

LET vComp = weekday(today());

load

day,

column1

resident table1

where day = $(vComp);

but while reloading it gives an error as "Field not found -- Thu". whereas wheren "day = 'Thu'  " condition is provided, then this load works

I also tried using chr(39) in variable declaration as

LET vComp = chr(39)&weekday(today())&chr(39);

but still not able to use it.

Can anyone provide me a solution for this.

Thanks for help

Aaditya

0 Replies