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

Where + 3 conditions

     Hi everybody,

I gat a question, i want to do a 3 conditions with where like that :

 

test:

LOAD [Code],

FROM

assur.qvd

(qvd) where [Code]='X'

and [Code]='Y

and [Code]='Z'

;

That's not works!

I tried ( where [Code]='X' and 'Y' and 'Z) too'..

But if i just do where

='X' , that is to say 1 condition, that works!!!

How can i do?

Thanks a lot!

1 Solution

Accepted Solutions
simenkg
Specialist
Specialist

you are missing a ' on the and [Code] = 'Y line.

But you will never get values here, as Code cannot both be X and Y at the same time.. Are you sure you do not mean OR?

Where [Code]='X' or [Code]='Y' or

='Z'

View solution in original post

3 Replies
simenkg
Specialist
Specialist

you are missing a ' on the and [Code] = 'Y line.

But you will never get values here, as Code cannot both be X and Y at the same time.. Are you sure you do not mean OR?

Where [Code]='X' or [Code]='Y' or

='Z'

crusader_
Partner - Specialist
Partner - Specialist

where wildmatch(

,'X','Y','Z')>0

Andrei

Not applicable
Author

Shame on me, that was "OR" , not 'AND' , thank you so much Simen!

(Yes i made a mistake , i missed the ' because i did a bad copy/paste!!

Thanks!!