topic Using MATCH and wildcards in QlikView

Using MATCH and wildcards

Wed, 11 Jul 2012 14:06:26 GMT

Hi everyone,

How could I search for all strings within OCWard which start with A and end with E? I was using this: -

,IF(MATCH(dept,'A&E','1'), 1,

IF(MATCH(OCWard,'A*E','ED'), 1,

IF(OCDestinationCode='1',0))) as ED_Ward2

But it doesn't find AYE, or A&E etc. What am I doing wrong?

Many thanks in advance.

nagaiank — Wed, 11 Jul 2012 14:12:19 GMT

Try to use

IF(WILDMATCH(OCWard,'A*E','ED'), 1,

and see if it works

Wed, 11 Jul 2012 14:56:12 GMT

Hi krishnamoorthy,

Works perfectly! Thank you very much.