topic Re: Using both ApplyMap and WildMatch in QlikView

Using both ApplyMap and WildMatch

Thu, 06 Nov 2014 00:08:52 GMT

I am getting an error on the below -- > ODBC read failed

if(Oppo_Product>0,

WildMatch(Oppo_Product,'*"mas90"*'),'Sage 100'),

WildMatch(Oppo_Product,'*"mas200"*'),'Sage 100',

WildMatch(Oppo_Product,'*"13"*'),'Sage 100',

WildMatch(Oppo_Product,'*"SageX3"*'),'Sage ERP X3',

ApplyMap('CustomCaptions1',Oppo_Product,) as Product,

The Mapping Table works without the WildMatch, but why not with it? I can't access the original mapping table. Is my best bet to just create a new mapping table and use that?

Can you not use WildMatch and ApplyMap for the same field?

Re: Using both ApplyMap and WildMatch

danieloberbilli — Thu, 06 Nov 2014 00:44:45 GMT

I think the problem is a wrong If-clause structure: you already close the if-clause with the last bracket in the second line...I guess that's not intended? Would you like the applymap to be applied on the updated labels created by Wildmatch?

Re: Using both ApplyMap and WildMatch

danieloberbilli — Thu, 06 Nov 2014 01:10:39 GMT

Maybe you are looking for something like this: