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
tan_chungkam
Contributor

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.pngimage.pngMy data source

1 Solution

Accepted Solutions
Partner
Partner

Re: Where Statement

hi 

just change your script 

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

View solution in original post

2 Replies
Partner
Partner

Re: Where Statement

hi 

just change your script 

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

View solution in original post

Highlighted
tan_chungkam
Contributor

Re: Where Statement

@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