Discussion Board for collaboration related to QlikView App Development.
Not a Qlikview developer, I've the formula working in excel but cant quite get it right in QV Not sure if QV has something similar to the "search" formula in excel?
=RIGHT(B2,LEN(B2)-SEARCH(" ",B2,SEARCH(" ",B2,1)+1))
Thanks a lot in advance and happy christmas
This answer replicates exactly my excel formula, however I realised my formula in excel wasn't working correctly for some cases.
Gysbert's formula worked better for me.
I have a field that contains information like this:
AB Leichire Heah POS0953
I only need the last part (POS0953) to create a new field with it.
The suggested by Gysbert works beautifuly:
subfield(B2,' ', -1)
Yes Gysbert is right
for pick last right value from AB Leichire Heah POS0953
you have to use subfield(B2,' ', -1)
Similary if you want last second then use subfield(B2,' ', -2)
Similary if you want last third then use subfield(B2,' ', -3)