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: 
tan_chungkam
Creator
Creator

Where Statement

Hi Lads,

I have table which has several company codes.

I would like to load only 300 and 310.

However it doesn't work.

Please find my scripting in the attachment and screenshot.

image.pngMy data sourceMy data source

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi 

just change your script 

replace the "and" with "or" in the where statement

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

just change your script 

replace the "and" with "or" in the where statement

tan_chungkam
Creator
Creator
Author

@lironbaram ,

Thanks a million.

It works. It would be nice if you explain why we can't use 'And'?

The reason i found another way to do that which is the script below.  And I'm using 'And' instead of 'Or'.

image.png