topic Re: How to pick the values in QlikView https://community.qlik.com/t5/QlikView/How-to-pick-the-values/m-p/798416#M1029038 <HTML><HEAD></HEAD><BODY><P>=SubField(values,'@@@',-1)</P></BODY></HTML> Thu, 26 Feb 2015 15:40:06 GMT MK_QSL 2015-02-26T15:40:06Z How to pick the values https://community.qlik.com/t5/QlikView/How-to-pick-the-values/m-p/798414#M1029034 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am having following values in my table</P><P><A href="mailto:nonprod@@@hydenwer">nonprod@@@hydenwer</A></P><P><A href="mailto:nonprod@@@hjanflsnlinhlslg">nonprod@@@hjanflsnlinhlslg</A></P><P><A href="mailto:nonprod@@@bsjkgbjkbjksbgjbkks">nonprod@@@bsjkgbjkbjksbgjbkks</A></P><P></P><P>From above I need pick the values only which is coming after "@" symbol</P><P></P><P>-Jay</P></BODY></HTML> Thu, 26 Feb 2015 15:37:43 GMT https://community.qlik.com/t5/QlikView/How-to-pick-the-values/m-p/798414#M1029034 Anonymous 2015-02-26T15:37:43Z Re: How to pick the values https://community.qlik.com/t5/QlikView/How-to-pick-the-values/m-p/798415#M1029036 <HTML><HEAD></HEAD><BODY><P>subfield(MyFieldHere, '@', -1)</P></BODY></HTML> Thu, 26 Feb 2015 15:39:02 GMT https://community.qlik.com/t5/QlikView/How-to-pick-the-values/m-p/798415#M1029036 Gysbert_Wassenaar 2015-02-26T15:39:02Z Re: How to pick the values https://community.qlik.com/t5/QlikView/How-to-pick-the-values/m-p/798416#M1029038 <HTML><HEAD></HEAD><BODY><P>=SubField(values,'@@@',-1)</P></BODY></HTML> Thu, 26 Feb 2015 15:40:06 GMT https://community.qlik.com/t5/QlikView/How-to-pick-the-values/m-p/798416#M1029038 MK_QSL 2015-02-26T15:40:06Z