topic Re: Last value in string in QlikView https://community.qlik.com/t5/QlikView/Last-value-in-string/m-p/1110959#M367430 <HTML><HEAD></HEAD><BODY><P>Try: subfield(Field, '-', -1)</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 20 May 2016 13:41:37 GMT marcus_sommer 2016-05-20T13:41:37Z Last value in string https://community.qlik.com/t5/QlikView/Last-value-in-string/m-p/1110958#M367429 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have Field values like,&nbsp; 001-AB-002-CD, 11-AB , AS-001-AK. Now I want to find the last value from string. For these values, I want to find CD,AB, AK</P></BODY></HTML> Fri, 20 May 2016 09:28:14 GMT https://community.qlik.com/t5/QlikView/Last-value-in-string/m-p/1110958#M367429 2016-05-20T09:28:14Z Re: Last value in string https://community.qlik.com/t5/QlikView/Last-value-in-string/m-p/1110959#M367430 <HTML><HEAD></HEAD><BODY><P>Try: subfield(Field, '-', -1)</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 20 May 2016 13:41:37 GMT https://community.qlik.com/t5/QlikView/Last-value-in-string/m-p/1110959#M367430 marcus_sommer 2016-05-20T13:41:37Z Re: Last value in string https://community.qlik.com/t5/QlikView/Last-value-in-string/m-p/1110960#M367431 <HTML><HEAD></HEAD><BODY><P>=mid(Field, index(Field,'-',-1)+1)</P></BODY></HTML> Fri, 20 May 2016 13:52:38 GMT https://community.qlik.com/t5/QlikView/Last-value-in-string/m-p/1110960#M367431 Kushal_Chawda 2016-05-20T13:52:38Z Re: Last value in string https://community.qlik.com/t5/QlikView/Last-value-in-string/m-p/1110961#M367432 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try right(Field, 2)</P></BODY></HTML> Fri, 20 May 2016 14:15:24 GMT https://community.qlik.com/t5/QlikView/Last-value-in-string/m-p/1110961#M367432 Anonymous 2016-05-20T14:15:24Z Re: Last value in string https://community.qlik.com/t5/QlikView/Last-value-in-string/m-p/1110962#M367433 <HTML><HEAD></HEAD><BODY><P>Values can be 3 or 4 or 5 digits it is not fixed. So it will not work. But really thanks for the reply</P></BODY></HTML> Fri, 20 May 2016 16:33:40 GMT https://community.qlik.com/t5/QlikView/Last-value-in-string/m-p/1110962#M367433 2016-05-20T16:33:40Z