topic Re: Changing name format displayed in Column in QlikView

Changing name format displayed in Column

rsdhavle — Wed, 13 Aug 2014 07:25:13 GMT

We want to change name format displayed in column. Lets say the name is displayed as Pratap, Ganesh..Mishra, Ritesh. I want to dsiplay it as Ganesh Pratap, Ritesh Mishra etc.. How can it be done? Which function can be used?

Re: Changing name format displayed in Column

kaushiknsolanki — Wed, 13 Aug 2014 07:29:32 GMT

Hi,

There is no function which can directly do this for you, but you will need to use some of the string functions to do this.

Load SubField(Name,',',2) & ' ' & SubField(Name,',',1) as New_Name,Name inline [

Name

"ABC, AAA"

"PQR, PPP"

];

Regards,

Kaushik Solanki