topic Re: string function in QlikView https://community.qlik.com/t5/QlikView/string-function/m-p/632471#M1089090 <HTML><HEAD></HEAD><BODY><P>Thank&nbsp; You I work Thank you for your help</P></BODY></HTML> Thu, 29 May 2014 09:47:45 GMT 2014-05-29T09:47:45Z string function https://community.qlik.com/t5/QlikView/string-function/m-p/632467#M1089086 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>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</P><P><IMG alt="" src="https://community.qlik.com/" /></P></BODY></HTML> Thu, 29 May 2014 09:31:49 GMT https://community.qlik.com/t5/QlikView/string-function/m-p/632467#M1089086 2014-05-29T09:31:49Z Re: string function https://community.qlik.com/t5/QlikView/string-function/m-p/632468#M1089087 <HTML><HEAD></HEAD><BODY><P>Sorry i forgot to add the image</P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/59754_pastedImage_0.png" style="width: auto; height: auto;" /></P><P></P><P>Please help me</P></BODY></HTML> Thu, 29 May 2014 09:36:18 GMT https://community.qlik.com/t5/QlikView/string-function/m-p/632468#M1089087 2014-05-29T09:36:18Z Re: string function https://community.qlik.com/t5/QlikView/string-function/m-p/632469#M1089088 <HTML><HEAD></HEAD><BODY><P>You could use index()</P><P></P><P>if(index(Title,'Manager')&gt;0,1,0) as ManagerFlag</P><P></P><P>This will give you a field in the data</P><P>1 = 'Manager' was found in the title field</P><P>0 = 'Manager' was NOT found in the title field</P><P>Regards</P><P>Richard</P><P>QlikCentral.Com</P></BODY></HTML> Thu, 29 May 2014 09:39:13 GMT https://community.qlik.com/t5/QlikView/string-function/m-p/632469#M1089088 richard_pearce6 2014-05-29T09:39:13Z Re: string function https://community.qlik.com/t5/QlikView/string-function/m-p/632470#M1089089 <HTML><HEAD></HEAD><BODY><P>try this</P><P>if(Wildmatch(fieldname,'*Manager'),fieldname) as Manager</P></BODY></HTML> Thu, 29 May 2014 09:39:45 GMT https://community.qlik.com/t5/QlikView/string-function/m-p/632470#M1089089 er_mohit 2014-05-29T09:39:45Z Re: string function https://community.qlik.com/t5/QlikView/string-function/m-p/632471#M1089090 <HTML><HEAD></HEAD><BODY><P>Thank&nbsp; You I work Thank you for your help</P></BODY></HTML> Thu, 29 May 2014 09:47:45 GMT https://community.qlik.com/t5/QlikView/string-function/m-p/632471#M1089090 2014-05-29T09:47:45Z Re: string function https://community.qlik.com/t5/QlikView/string-function/m-p/632472#M1089091 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">if(fieldname Like '*Manager*',fieldname) as Manager</SPAN></P></BODY></HTML> Thu, 29 May 2014 10:22:37 GMT https://community.qlik.com/t5/QlikView/string-function/m-p/632472#M1089091 anbu1984 2014-05-29T10:22:37Z