Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Name |
Parvinder Kaur |
John P Gonsalve |
Ritesh Gupta |
Anita G Rodrigues |
Deepali R Jahav |
Rupesh J Sonawane |
Fatima C Fernandes |
Sunil S Singh |
Rohit J Gupta |
How do I remove the middle name and display the First Name n Last Name.
Make sure you mark a correct answer to close the thread.
I always refresh before replying to a post - so that I know that nobody before me has given a better answer . I think the QlikView team should include / improve AJAX for this forum as well so that things get updated live.
This is because sometimes members are replying to selecting reply of some other members rather than selecting the original post.
Still not sure why those responses didn't show either before or after I posted a reply. After refreshing my response was third on the list. Anyway - as I say - not a big deal. As long as a helpful answer is received!!
How about this? It works for the names without a middle name as well.
if(len(SubField(GetFieldSelections(Name),' ',2))=1, Replace(GetFieldSelections(Name),' ' & SubField(GetFieldSelections(Name),' ',2) &' ',' '), GetFieldSelections(Name))
I m new to qlikview n i think this is too confusing
Like these
Please find the attached file you may see desired result
this is also working
Thank u