topic Where + 3 conditions in QlikView

Where + 3 conditions

Thu, 07 Aug 2014 13:17:14 GMT

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!

simenkg — Thu, 07 Aug 2014 13:18:36 GMT

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_ — Thu, 07 Aug 2014 13:20:31 GMT

where wildmatch(

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

Andrei

Thu, 07 Aug 2014 13:22:28 GMT

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