Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
wesbrowning
New Contributor III

IF statement to match string within field

I've been trying many ideas but no luck and hoping the community can assist. 

I am wanting to "look" within a field and when I match a particular string of characters, in this case "IBM", return a "Yes" text string into my table.  Something like:

=IF[(Field) Contains string(IBM), Return "Yes"]

I know that's not proper syntax but hoping writing out the logic conveys my goals better.

Any help greatly appreciated!  Thanks... Wes

Tags (2)
1 Solution

Accepted Solutions

Re: IF statement to match string within field

You can also try this

If(Field LIKE '*IBM*', 'Yes')

3 Replies

Re: IF statement to match string within field

Try this

If(WildMatch(Field, '*IBM*'), 'Yes')

Re: IF statement to match string within field

You can also try this

If(Field LIKE '*IBM*', 'Yes')

wesbrowning
New Contributor III

Re: IF statement to match string within field

Thanks Sunny!  This is perfect...

Community Browser