topic Re: Wrap Legends in bar chart in QlikView

Wrap Legends in bar chart

chhavi376 — Thu, 09 Mar 2017 09:16:53 GMT

Hi All,

Can we wrap the legends of a bar chart?

By wrap, i don't mean wrapping the text of the legends but i want that there should be two rows of the legends as we want to see all the values at one time rather than using arrows to scroll up or down.

Please tell me if there is any way to do this.

Re: Wrap Legends in bar chart

rahulpawarb — Thu, 09 Mar 2017 09:48:49 GMT

Hello Chhavi,

Please refer attached sample application.

Regards!

Rahul

Re: Wrap Legends in bar chart

chhavi376 — Thu, 09 Mar 2017 13:01:14 GMT

Hey,

i think you misunderstood.

I want to avoid these arrows which i have highlighted in red, and i want the legends to be displayed in two columns.

Re: Wrap Legends in bar chart

Anil_Babu_Samineni — Thu, 09 Mar 2017 13:15:05 GMT

May be mouse over to the Legend and drag to the height of the legend

Or move to the down and move into the Horizontal

Re: Wrap Legends in bar chart

rahulpawarb — Thu, 09 Mar 2017 13:20:04 GMT

Hello Chhavi,

Select the chart and press Ctrl + Shift; post that resize the height of legend.

Hope this will help you.

Regards!

Rahul

Re: Wrap Legends in bar chart

chhavi376 — Fri, 10 Mar 2017 04:31:56 GMT

Actually the number of values in the legends are more, i have tried to increase the height as well, but it still doesnt fit in. and i cannot increase the height of the chart.

Horizontal is also not working.

So i was looking for an alternative, may be if i could distribute it into 2 columns. But i am not able to achieve that

Re: Wrap Legends in bar chart

Anil_Babu_Samineni — Fri, 10 Mar 2017 04:53:24 GMT

Make sense, But we can't do with single object as per your need. But, we can make diff objects and then club into one

First Approach: Second Approach:

Note: Which approach you liked it, In the second option you may not get with the color prompt which shows in Pie chart legend, And here i've done with List box called the calculated expression Aggr(FieldName, FieldName) and i did custom on layout. Even, If we changed the sort from User then it should change like below

Note: If you don't want green selector that we have control to change.

Re: Wrap Legends in bar chart

rahulpawarb — Fri, 10 Mar 2017 05:25:38 GMT

Hello Chhavi,

You can make use of Restrict which values are displayed using the first expression option present under Dimension Limit tab of chart properties. Select Show only option with Largest 10 values. The Largest option returns the rows in descending order based on the first expression in the chart.

Select Show Others option to produce an Others segment in the chart. All dimension values that do not meet the comparison criteria for the display restrictions will be grouped into the Others segment.

Once done with this then you can see the Top 10 values including Others. If you want to know more about Others then you can click on Others this Top 10 values present under Others (This will create new Others within Others) and so on.

Hope this will help.

Regards!

Rahul

Re: Wrap Legends in bar chart

chhavi376 — Thu, 16 Mar 2017 05:45:43 GMT

Okay, thanks

Re: Wrap Legends in bar chart

chhavi376 — Thu, 16 Mar 2017 05:46:13 GMT

thanks!

Re: Wrap Legends in bar chart

Anil_Babu_Samineni — Thu, 16 Mar 2017 05:52:13 GMT

Hope you got answer, If so please close the thread by flag Correct Answer. Or else please ask freely if need more information

Re: Wrap Legends in bar chart

krishna789 — Mon, 27 Mar 2017 09:55:17 GMT

hi anil babu

i want first method scrollbar can you share with example .pls

Re: Wrap Legends in bar chart

Anil_Babu_Samineni — Mon, 27 Mar 2017 10:02:10 GMT

I have nothing done. Here, You have to get two objects one is Pie chart and one more should be List box. Here you need to Custom or overlap to the pie chart. And then make nice and clean. I will offer you if you share the data and here you need to work around of list box like back ground color of selections and then expression should be Aggr(FieldName, FieldName) to retrieve only possible values on overlap.