topic Re: Legends at bottom: can't align horizontally in QlikView

Legends at bottom: can't align horizontally

zagzebski — Tue, 07 Jul 2015 01:15:22 GMT

I have tried everything but can't get the legend (attached) to go across the bottom horizontally instead of being stack vertically like the attached. I tried resetting the user docking, turning off the legend then back on, trying to move and resize the legend using ctrl/shift.

Can somebody provide advice? I have other graphs with this same issue and don't want to redo all of them!

Thanks in advance,

Steve

Re: Legends at bottom: can't align horizontally

arthur_dom — Tue, 07 Jul 2015 01:46:42 GMT

You could put values inside the bars... ( on presentation, it is a check box) .

Re: Legends at bottom: can't align horizontally

zagzebski — Tue, 07 Jul 2015 02:14:00 GMT

Arthur - I am talking about the legend (2012, 2013, 2014....)

Steve

Re: Legends at bottom: can't align horizontally

settu_periasamy — Tue, 07 Jul 2015 02:20:06 GMT

Hi,

is it possible to provide sample?

Re: Legends at bottom: can't align horizontally

settu_periasamy — Tue, 07 Jul 2015 02:23:45 GMT

Hi,

Try this.

Dear QlikViewers,

There is a way to show the legend horizantally with few work arounds. Pls. follow the steps to do:

1. Press shift+ctrl+alt buttons together and move the vertical legend at the bottom of the chart.

2. Release the mouse button

3. Now it will be in vertical still at the bottom of the chart.

4. Press the shift+ctrl+alt buttons together again and resize the buttom square to reduce the height of the box.

5. Now your legend should show horizantally at the bottom of the chart.

Please test it. Thanks.

Best Regards,

MOHAN

Show Legend horizantally

Re: Legends at bottom: can't align horizontally

arthur_dom — Tue, 07 Jul 2015 02:24:19 GMT

did you try using CTRL+Shift in the graph to resize the legend size?

Re: Legends at bottom: can't align horizontally

Anonymous — Tue, 07 Jul 2015 02:29:49 GMT

Hi,

You have to right click on chart, then click Ctrl+Shift and drag you legend. if it did not come properly you can reset it by going to General tab and click on reset user sizing and docking buttons and try again from start.

Re: Legends at bottom: can't align horizontally

Anonymous — Tue, 07 Jul 2015 02:30:46 GMT

Hi,

Please go through this thread:

Re: Legends at bottom: can't align horizontally

jagan — Tue, 07 Jul 2015 02:41:34 GMT

Hi,

Before moving the legend to the bottom click the following buttons

Chart Properties-> General -> Click on Reset User Sizing and Docking buttons.

Then click on the chart and hold Ctrl + Shift buttons together and drag it to the bottom until you see the Red border.

Hope this helps you.

Regards,

jagan.

Re: Legends at bottom: can't align horizontally

zagzebski — Tue, 07 Jul 2015 12:50:43 GMT

Sample is below. No matter how I try to move the legend I can't get the dates to go to horizontally aligned. By default they usually do but I was experimenting with the legend and now can't get it back.

Re: Legends at bottom: can't align horizontally

zagzebski — Tue, 07 Jul 2015 12:52:22 GMT

Arthur yep - tried the control shift but all I can do is move around the legend - not straighten make the legend values horizontal at bottom.

Re: Legends at bottom: can't align horizontally

sunny_talwar — Tue, 07 Jul 2015 12:53:44 GMT

By sample we mean a sample qvw document

Re: Legends at bottom: can't align horizontally

Anonymous — Tue, 07 Jul 2015 12:57:20 GMT

try this: press CTRL/SHFT to see red boxes

select the box with your years and move it down until the box is over the complet wide of the Chart (not as in the Picture, but complet from left to right)

then shorten the year box (move the arrows up/down) until there is only place for one year

the years should be spread horizontally

Re: Legends at bottom: can't align horizontally

zagzebski — Tue, 07 Jul 2015 13:18:34 GMT

Rudolf - I am close. I got it to go horizontal but my graph shrunk up. When I try to make the graph portion bigger it stacks the legend vertically again. Thanks for the help!

Re: Legends at bottom: can't align horizontally

Anonymous — Tue, 07 Jul 2015 13:44:40 GMT

I suppose that the lenght of the legend causes the Problem. try to Change the orientation of the legend to horzontal or to shorten the number of charactres

Re: Legends at bottom: can't align horizontally

Anonymous — Tue, 07 Jul 2015 13:50:26 GMT

another Option would be to shorten the box with years horizontally (but still that all years are visible)

then place the box with years somewhere on your Chart where it does not hide any information

(it's like overlaying).

Re: Legends at bottom: can't align horizontally

Anonymous — Wed, 15 Jul 2015 07:55:14 GMT

Hi Zagzebski,

Even I was breaking my head into it, until I realised that you have to drag in such a way that after resetting the user sizing and dock settings,

take it (the red dragging box which becomes black while dragging) slowly to the edge of the chart in a manner that the box itself will turn horizontal while still being dragged. Then leave it.

I know its difficult to understand in text, gotto try by takiing the box to the edge of chart slowly.

Hope it helps.

Regards,

Ruchi Bagaria

Re: Legends at bottom: can't align horizontally

zagzebski — Wed, 15 Jul 2015 12:13:08 GMT

Thanks - definately see if that helps.

Re: Legends at bottom: can't align horizontally

Thu, 30 Jul 2015 17:41:59 GMT

Jagan is correct. Please see: Make LEGEND Horizontal Display instead of Vertical