topic Splitting the label name in QlikView

Splitting the label name

jelly_gvm — Tue, 04 Aug 2015 12:18:53 GMT

Hello Team,

I my dashboard I have field label name called [Transmission Name], but i want to split the label name into two sub-fields

The below label name is old format.

Transmission Name

To display the label name in the below format.

Transmission Name

Appreciate your help.

Thanks in Advance

Regards,

Ram

Re: Splitting the label name

sorrakis01 — Tue, 04 Aug 2015 12:22:14 GMT

Hi,

Try this,

'Transmission Name' & Chr(13) & 'Name'

Regards

Re: Splitting the label name

PrashantSangle — Tue, 04 Aug 2015 12:24:03 GMT

Hi,

Various way to acheive it.

1) Reduce column width

2)in Label Name write ='Transmission'&chr(13)&'Name'

in Label Name write ='Transmission'&chr(10)&'Name'

and go to Presentation tab->Wrap Header Text(Select it).

Regards

Re: Splitting the label name

robert_mika — Tue, 04 Aug 2015 12:28:02 GMT

Another one:

'Transmission Name' & Chr(10) & 'Name'

Re: Splitting the label name

Tue, 04 Aug 2015 12:31:54 GMT

If this a a column label, the easiest way is state above with narrowing the column width, assuming it does not effect displaying of the ata in the column, select wrap header text on presentation tab and select 2 rows

Re: Splitting the label name

jelly_gvm — Tue, 04 Aug 2015 13:52:28 GMT

Thanks you all this problem was solved by using the subfield()