Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
akpofureenughwu
Contributor II

Select name character

Hello everyone,

I have a table of staff name I pulled from sql,

First NameMiddle NameLast NameCode
JohnN/ALee001
KittyBrownFrankie002
TracyMoleChuck003
GrantN/ASam004

This is the sample of the data.  N/A is there because the staff doesn't have a middlename.

I need to concatenate the First Name, Middle Name and Last Name  to give Full Name

I'm using this expression:

Last_Name&' '&"Middle_Name"& ' '&First_Name as [Full Name]

but if I use the above expression for the staff with code 001.. full name will become John N/A Lee and this is not valid

How do I edit it so I will skip Middle Name when Middle Name  = 'N/A'

1 Solution

Accepted Solutions

Re: Select name character

Last_Name&' '& if(Middle_Name<> 'N/A', Middle_Name & ' ', '') & First_Name as [Full Name]


-Rob

http://masterssummit.com

http://qlikviewcookbook.com

4 Replies

Re: Select name character

Last_Name&' '& if(Middle_Name<> 'N/A', Middle_Name & ' ', '') & First_Name as [Full Name]


-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Select name character

May be try this

Last_Name & If(Middle_Name <> 'N/A', ' ' & Middle_Name) & ' ' & First_Name as [Full Name]

Re: Select name character

Hi,

another solution could be:

QlikCommunity_Thread_269907_Pic1.JPG

Replace([First Name]&' '&[Middle Name]&' '&[Last Name],' N/A','') as [Full Name]

hope this helps

regards

Marco

akpofureenughwu
Contributor II

Re: Select name character

Thank you Marco. This is great

Community Browser