topic Re: Wildmatch () function does not work with apostrophe in QlikView

Wildmatch () function does not work with apostrophe

claudialet — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

sunny_talwar — Wed, 13 Feb 2019 17:42:23 GMT

Have you tried with the Escape sequences

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

claudialet — Wed, 13 Feb 2019 18:16:46 GMT

thanks got it