Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

where wildmatch(

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

Andrei

Highlighted
Not applicable

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!!