topic Re: Name display in QlikView

Name display

Tue, 29 Sep 2015 15:20:31 GMT

I have a column called Name

ex:Name

Rai,Sam

where Sam is first name and Rai is last name

so I only want to display last name.How can I do that ?

Digvijay_Singh — Tue, 29 Sep 2015 15:22:44 GMT

Use subfield if comma is the delimiter -

Subfiled(Name,',',1) as Lastname

sunny_talwar — Tue, 29 Sep 2015 15:25:08 GMT

My bad

Gabriel — Tue, 29 Sep 2015 15:53:55 GMT

Hi,

You can split the field in the script

LOAD

NAME,

Subfield(NAME,','1) AS FirstName,

Subfield(NAME,',',2) AS LastName

,....

From Source;

Then in UI you can use LastName field as you want.

Tue, 29 Sep 2015 15:55:52 GMT

Try Subfield(name,','1) AS FirstName

Tue, 29 Sep 2015 16:26:34 GMT

subfield(name,',',1) as lastname.

use it may help

Tue, 29 Sep 2015 17:10:05 GMT

Thank you very much.