Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
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

2 Replies
Partner
Partner

Re: Where Statement

hi 

just change your script 

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

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