How to split Legend Name in Bar chart

[SatyaPaleti]

Hi Folks,

Can you guys please help me to how to split legend name in Bar Chart

You can find sample data and sample qvw. Please find attachment. Please help me to resolve this Issue

Thanks and Regards,

Satya

[krishnacbe]

Hi,

Only way is to edit your data in Excel. Please check the attachment

[trdandamudi]

It is not possible exactly the way you want it but hope the below will help: Use Replace() for your dimension as shown in the screen shot and you will get the output shown in the screen shot below. Hope this helps...

[sergio0592]

Hi,

It works with :

=left(Customer,FindOneOf(Customer,' ',2)-1)&chr(10)&mid(Customer,FindOneOf(Customer,' ',2)+1)

[rwunderlich]

See Displaying long labels on chart X-axis

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[neha_shirsath]

Hi Satya,

Try with below script-

LOAD //Customer,

     sales,

     budget,

     subfield(Customer,' ',1) & chr(12)  & chr(10)&subfield(Customer,' ',2)& chr(12)& chr(10)&subfield(Customer,' ',3)& chr(12)& chr(10)&subfield(Customer,' ',4)

        & chr(12)& chr(10)&subfield(Customer,' ',5)& chr(12)& chr(10)&subfield(Customer,' ',6)  as Customer

FROM

Test.xls

(biff, embedded labels, table is [Sheet1$]);

Thanks,

Neha