topic Re: AND OR CONDITIONS in QlikView

AND OR CONDITIONS

ankit777 — Thu, 08 May 2014 14:09:00 GMT

hi All,

I have a table with three columns A,B,C.

There are null values in B and C.

I want to create another table from the above table where either B is null or C is null.

I dont want to include records where both B & C are nul or not null. I want records for which either B is null or c is Null.

Plz Help.

its_anandrjs — Thu, 08 May 2014 16:49:49 GMT

Can you provide any sample data.

Thu, 08 May 2014 17:07:49 GMT

Please use this

Load * where (Not isnull(B) and IsNull(C)) or (isnull(B) and not isnull(C));

Example attached

Thanks

Thu, 08 May 2014 17:11:00 GMT

Better way:

Load * where Isnull(B) xor Isnull(C);

ankit777 — Fri, 09 May 2014 05:18:10 GMT

Thanks Ajay, XOR works perfectly for me. Cheers...!!!