Discussion board where members can get started with QlikView.
I was trying to get only the last name and the first name of one employee,
Curtiz, Jinky Lyza,
How to get only Curtiz,Jinky.
Just use this expression :
=left('Curtiz, Jinky Lyza',index('Curtiz, Jinky Lyza',' ',2))
View solution in original post
its not working.
I have this fieldname.
already got the answer. thank you..