string function

[#1]

Hi,

i have a table like this. in this i want the person who are working as a manager. How can i get.please help me

[#2]

Sorry i forgot to add the image

Please help me

[richard_pearce6]

You could use index()

if(index(Title,'Manager')>0,1,0) as ManagerFlag

This will give you a field in the data

1 = 'Manager' was found in the title field

0 = 'Manager' was NOT found in the title field

Regards

Richard

QlikCentral.Com

[er_mohit · Accepted solution]

try this

if(Wildmatch(fieldname,'*Manager'),fieldname) as Manager

[#5]

Thank  You I work Thank you for your help

[anbu1984]

if(fieldname Like '*Manager*',fieldname) as Manager