Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sorry i forgot to add the image
Please help me
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
try this
if(Wildmatch(fieldname,'*Manager'),fieldname) as Manager
Thank You I work Thank you for your help
if(fieldname Like '*Manager*',fieldname) as Manager