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: 
claudialet
Contributor III
Contributor III

Wildmatch () function does not work with apostrophe

 Hello

 

Here is my expression :

 

WildMatch( DetailsLevel ,'Owner's Income',
'Foreign Income') = 0

The issue is I have other fields where it starts with 'Owner's. I only need to not display 'Owner's Income' 

 

When I use this : 'Owner *'  it removes the other fields that also starts with 'Owner's'. 

 

Any ideas how to deal with apostrophes in field names ?

1 Solution

Accepted Solutions
sunny_talwar

Have you tried with the Escape sequences

WildMatch( DetailsLevel ,'Owner''s Income', 'Foreign Income') = 0

View solution in original post

2 Replies
sunny_talwar

Have you tried with the Escape sequences

WildMatch( DetailsLevel ,'Owner''s Income', 'Foreign Income') = 0
claudialet
Contributor III
Contributor III
Author

 thanks got it