Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. 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.