search in set analysis

[#1]

Good day!

Please help to search text value in set analysis.

For example, I need to find all managers in field [CR_L3_Code] which contains 'Kvs' and join them tothe general name 'Kiev' in the dimension .

It seems to be easy, using the '*', but formula like this doesn't work:

if([CR_L3_Code]='*Kvs*', 'Kiev', 'no') 

CR_L3_Code	=   if([CR_L3_Code]='*Kvs*','Kiev','no')
UM-Kvs-C-TT-1	no
UM-Dnp-S-TT	no
UM-Dnt-C-AL-2	no
UM-Kvs-D-AL	no
UM-Dnt-S-OT	no

What can be wrong?

Thanks in advance!

[tresesco]

Try using WildMatch()

[CELAMBARASAN · Accepted solution]

Try

If(WildMatch([CR_L3_Code], '*Kvs*'),'Kiev', 'no')

[#4]

It works! Thanks a lot!!!