topic Re: mixmatch function in QlikView https://community.qlik.com/t5/QlikView/mixmatch-function/m-p/394412#M147085 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check attached just in case, but that expression is actually working.</P><P></P><P>Regards.</P><P></P><P>Miguel</P></BODY></HTML> Tue, 09 Oct 2012 13:41:48 GMT Miguel_Angel_Baeyens 2012-10-09T13:41:48Z mixmatch function https://community.qlik.com/t5/QlikView/mixmatch-function/m-p/394411#M147084 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>The statement below returns nothing, the BRANCH has upper and lower case data items.Thanks</P><P></P><P></P><TABLE><TBODY><TR><TD>IF(MixMatch(BRANCH,'DOME','MAKOLA' ,'AVENOR','MUUS'),'GREATER ACCRA',&nbsp; </TD><TD> </TD></TR><TR><TD>IF(BRANCH='SWEDRU','CENTRAL',&nbsp; </TD><TD> </TD></TR></TBODY></TABLE><P>IF(BRANCH ='KUMASI','ASHANTI',Null()))) as Region,</P></BODY></HTML> Tue, 09 Oct 2012 13:24:37 GMT https://community.qlik.com/t5/QlikView/mixmatch-function/m-p/394411#M147084 Anonymous 2012-10-09T13:24:37Z Re: mixmatch function https://community.qlik.com/t5/QlikView/mixmatch-function/m-p/394412#M147085 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check attached just in case, but that expression is actually working.</P><P></P><P>Regards.</P><P></P><P>Miguel</P></BODY></HTML> Tue, 09 Oct 2012 13:41:48 GMT https://community.qlik.com/t5/QlikView/mixmatch-function/m-p/394412#M147085 Miguel_Angel_Baeyens 2012-10-09T13:41:48Z