Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

mixmatch function

Hi

The statement below returns nothing, the BRANCH has upper and lower case data items.Thanks

IF(MixMatch(BRANCH,'DOME','MAKOLA' ,'AVENOR','MUUS'),'GREATER ACCRA', 
IF(BRANCH='SWEDRU','CENTRAL', 

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

1 Reply
Miguel_Angel_Baeyens

Hi,

Check attached just in case, but that expression is actually working.

Regards.

Miguel