topic Select * WHERE FIELD1 = Value1 OR FIELD2 = VALUE2 in QlikView

Select * WHERE FIELD1 = Value1 OR FIELD2 = VALUE2

Thu, 23 Feb 2012 14:41:30 GMT

Hi Everyone,

I've got a question, which may sound stupid. Sorry if it is.

Does Qlikview allows to do 'OR' selections. For example, I'd like to select a customer and a region, and then see all the sales related to this customer OR this region.

Thanks in advance,

Igor

Select * WHERE FIELD1 = Value1 OR FIELD2 = VALUE2

mdmukramali — Thu, 23 Feb 2012 14:54:08 GMT

Dear,

igor.

yes qlikview will allow to perform OR sel;ection.

but in our case it will perofrm AND Operation.

if you select 2 customers then it wil perform OR operation ,

if you select 1 customer and one region then it will perform AND operation.

so you will get the result for that customer and that slected region sales.

hope it will help you.

Thanks,

mukram.

Select * WHERE FIELD1 = Value1 OR FIELD2 = VALUE2

Thu, 23 Feb 2012 15:01:30 GMT

Thanks a lot for the reply, Mukram.