Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.