topic Re: How to split Legend Name in Bar chart in QlikView

How to split Legend Name in Bar chart

SatyaPaleti — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to split Legend Name in Bar chart

krishnacbe — Mon, 24 Jul 2017 20:43:15 GMT

Hi,

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

Re: How to split Legend Name in Bar chart

trdandamudi — Mon, 24 Jul 2017 21:10:47 GMT

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...

Re: How to split Legend Name in Bar chart

sergio0592 — Mon, 24 Jul 2017 21:37:27 GMT

Hi,

It works with :

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

Re: How to split Legend Name in Bar chart

rwunderlich — Mon, 24 Jul 2017 23:01:46 GMT

See Displaying long labels on chart X-axis

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: How to split Legend Name in Bar chart

neha_shirsath — Tue, 25 Jul 2017 05:25:46 GMT

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