Discussion Board for collaboration related to QlikView App Development.
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
Go to Solution.
Try: subfield(Field, '-', -1)
View solution in original post
Try right(Field, 2)
Values can be 3 or 4 or 5 digits it is not fixed. So it will not work. But really thanks for the reply