Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

IF statement doesnt return all

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

1 Solution

Accepted Solutions
rajni_batra
Specialist
Specialist

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

View solution in original post

3 Replies
rajni_batra
Specialist
Specialist

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
Partner - Specialist
Partner - Specialist

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
Not applicable
Author

Thanks a lot