topic AND function in QV? in QlikView

AND function in QV?

Wed, 06 Jun 2012 09:15:19 GMT

Hello Everyone,

I am quite new in developing tabs in QV and now I am facing a challenge: I can't find an equivalent of the excel function AND in QV, same thing for OR.

Can someone help me on this ?

Many thanks for your efforts

AND function in QV?

SunilChauhan — Wed, 06 Jun 2012 09:21:30 GMT

if( field=1 and field=2 ,'Hello') for and

if( field=1 or field=2 ,'Hello') for or

or in load

Load *

from path where field=1 and field=2;

Load *

from path where field=1 or field=2;

hope this helps

AND function in QV?

Wed, 06 Jun 2012 13:11:23 GMT

Thanks to a combination of the two I got what I was looking for !!! Many thanks for your help and have a nice day