Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
Author

Hi krishnamoorthy,

Works perfectly! Thank you very much.