Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using MATCH and wildcards

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.

2 Replies
nagaiank
Specialist III
Specialist III

Try to use

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

and see if it works

Not applicable

Hi krishnamoorthy,

Works perfectly! Thank you very much.