topic Re: Last Name, First Name in QlikView

Last Name, First Name

Mon, 02 Jun 2014 18:30:12 GMT

Hi,

In my script I have:

Load

[Last Name],

[First Name]

From...

Is there a way to join the fields so that the data would appear as "Last Name, First Name" in a list box on the dashboard?

Thank you,

its_anandrjs — Mon, 02 Jun 2014 18:33:46 GMT

Load your table like

Load

'[Last Name] &' , '&[First Name] as Last&Full

From...

its_anandrjs — Mon, 02 Jun 2014 18:38:40 GMT

if you need exactly same as your output that is "Last Name, First Name"

Load

[First Name],

[Last Name],

Chr(34)&[Last Name] &' , '&[First Name]&Chr(34) as Last&Full

From...