topic Re: How to set legends in bar charts in QlikView

How to set legends in bar charts

vikasmahajan — Wed, 12 Jun 2013 04:06:19 GMT

Dear all

I have following bar graph in my view legends are not display properly please see attached jpg file

How do I setting for neat and clean chat.

Thanks

Vikas

Re: How to set legends in bar charts

sujeetsingh — Wed, 12 Jun 2013 04:20:33 GMT

Hi,

It need to expand your chart size.

-Go on chart and press CTRL+SHIFT and then adjust the size of legend

-Go to Presentation Tab and on Show legend go to Settings and the set Font Size too,

hope it work

Re: How to set legends in bar charts

tresB — Wed, 12 Jun 2013 04:25:15 GMT

In the presentation tab, you can limit the visible number of character (check - "Limit Legends (Characters)"). Or, you may want to change the orientation of the legend in Axes ("Primary Dimension Label"). If the number of dimension member is high, you can limit the visible member number allowing scrolling ("Enable X-Axis Scrolling" in presentation tab). Or even you want to resize and reposition the apprearance of them(select the chart -> press Ctrl+Shift).

Hope this helps.

Re: How to set legends in bar charts

vikasmahajan — Wed, 12 Jun 2013 04:29:39 GMT

Done this already but still I want to reduce the size of legends to clear and neat dashboard.

Thanks.

Vikas

Re: How to set legends in bar charts

Wed, 12 Jun 2013 06:19:24 GMT

you can write in this ways also with multiple if conditions

=if(len(trim(YourDimension)>30,left(YourDimension,15) & Chr(10) & Mid(YourDimension,16,15) & chr(10) & right(1))