Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Last value in string

Hi,

I have Field values like,  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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Last value in string

Try: subfield(Field, '-', -1)

- Marcus

View solution in original post

4 Replies
MVP & Luminary
MVP & Luminary

Re: Last value in string

Try: subfield(Field, '-', -1)

- Marcus

View solution in original post

Re: Last value in string

=mid(Field, index(Field,'-',-1)+1)

rominavilla
New Contributor III

Re: Last value in string

Hi,

Try right(Field, 2)

Not applicable

Re: Last value in string

Values can be 3 or 4 or 5 digits it is not fixed. So it will not work. But really thanks for the reply