topic Re: IF statement doesnt return all in QlikView

IF statement doesnt return all

Anonymous — Wed, 26 Sep 2012 10:48:23 GMT

Hi,

can someone please tell me what's wrong with this statement.

If(BRANCH ='DOME' OR 'MAKOLA' OR 'AVENOR' OR 'MUUS','GREATER ACCRA',IF(BRANCH = 'SWEDRU','CENTRAL',IF(BRANCH ='KUMASI','ASHANTI',NULL()))) as Region;

when i select GREATER ACCRA from Region it only shows DOME and not the rest MAKOLA, AVENOR and MUUS.

Thanks

rajni_batra — Wed, 26 Sep 2012 11:04:41 GMT

if statement does not work like this

use

if (Match(Branch,'DOME','MAKOLA' ,'AVENOR','MUUS'),'GREATER ACCRA',

if(Branch='SWEDRU','CENTRAL',

IF(BRANCH ='KUMASI','ASHANTI',Null()))) as Region

nilesh_gangurde — Wed, 26 Sep 2012 11:09:29 GMT

IF(wildmatch(BRANCH ,'DOME' , 'MAKOLA' , 'AVENOR' , 'MUUS') , 'GREATER ACCRA',

IF(wildmatch(BRANCH = 'SWEDRU') , 'CENTRAL',

IF(wildmatch(BRANCH ,'KUMASI') , 'ASHANTI',

NULL()))) as Region

Regards,

Nilesh Gangurde

Anonymous — Wed, 26 Sep 2012 11:10:06 GMT

Thanks a lot