topic RECODE in QlikView

RECODE

Anonymous — Mon, 23 Jun 2014 15:34:36 GMT

hi guys,

Please help with idea how to recode all remaining tags to one tag

IF(wildmatch([AAA],'*support*'),'Came for support',IF(WildMatch([Primary purpose of visit], not '*support*'),'Others') ) as [Primary purpose of visit],

Thanks,

Re: RECODE

alexandros17 — Mon, 23 Jun 2014 15:41:10 GMT

IF(wildmatch([Primary purpose of visit],'*support*')>0,'Came for support','Others')

) as [Primary purpose of visit],

Re: RECODE

its_anandrjs — Mon, 23 Jun 2014 15:41:19 GMT

Try this way

IF(Wildmatch([AAA],'*support*'),'Came for support',

IF(Not WildMatch([Primary purpose of visit], '*support*'),'Others') ) as [Primary purpose of visit]