Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
Partner

hi 

just change your script 

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

View solution in original post

2 Replies
lironbaram
Partner
Partner

hi 

just change your script 

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

View solution in original post

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