topic Re: legend in a bar chart in QlikView

legend in a bar chart

Tue, 01 Mar 2016 11:03:34 GMT

Hi,

It is possible to show numbers in legend on a pie chart - see option below.

However, this option does not seem to be possible on a bar chart (same tick box isn't there). Is it possible to add this on?

You will see the cahrt we have - where the legend is instead of 16-24, 25-35 we ideally wnat the colours to show but then show the numbers (e.g 50, 100 etc). Is this possible?

Chris

Re: legend in a bar chart

Anonymous — Tue, 01 Mar 2016 11:07:18 GMT

like this?

Pie chart with number and percent

Pie chart having both Values and Percentages | The QlikView Design Blog

Re: legend in a bar chart

Anonymous — Tue, 01 Mar 2016 11:09:17 GMT

Or Simply Add one more same expression in Number Format and promote it.

Untick Relative & Change the format to Number

Re: legend in a bar chart

stephenedberkg — Tue, 01 Mar 2016 11:13:43 GMT

its not possible in bar chart.

you can use

only two dimensions

and more than 1 expression

Re: legend in a bar chart

Tue, 01 Mar 2016 11:15:06 GMT

No - we want to look this this but be a bar chart:

Re: legend in a bar chart

Anonymous — Tue, 01 Mar 2016 11:22:38 GMT

Not possible in Bar Chart

Re: legend in a bar chart

Tue, 01 Mar 2016 11:35:54 GMT

Thanks.

One other question is it possible to remove the top column with text and just show numbers?

Chris

Re: legend in a bar chart

Chanty4u — Tue, 01 Mar 2016 11:38:20 GMT

in which chrt?

Re: legend in a bar chart

Tue, 01 Mar 2016 11:43:33 GMT

its a straight table

Re: legend in a bar chart

Chanty4u — Tue, 01 Mar 2016 11:45:22 GMT

use custom format cell and do colur as white or u can create a text object and place top of that and in layout layer as top and unchk move or copy option.

Re: legend in a bar chart

Tue, 01 Mar 2016 11:49:04 GMT

Great - which tab is custom format cell on?

Re: legend in a bar chart

Chanty4u — Tue, 01 Mar 2016 11:52:37 GMT

which the names u want to hide select dat filed names...and do custm format

Re: legend in a bar chart

Anonymous — Tue, 01 Mar 2016 11:53:54 GMT

Yuo mean to say, You dont want to show Age Band, Is It??

Re: legend in a bar chart

Tue, 01 Mar 2016 12:00:58 GMT

This is the chart - we ideally done want to show the straight table column below chart with age bands on. We can just hide it behind chart but wondering if there was an option to just remove the column.

We also want to remove the legend but when you untick this they then go on the x axis - hence the desire to hide in straight table below.

Is there any ability to widen width of bars without having to extend width of box.

Re: legend in a bar chart

avinashelite — Tue, 01 Mar 2016 12:17:04 GMT

write a if condition like if(column_name="Age Incorrect" or column_name="Age Not Known",null(), column_name)

Hope this helps you

Re: legend in a bar chart

Tue, 01 Mar 2016 12:20:30 GMT

Hi,

Thanks for this. Where do I add this on the properties?

Chris

Re: legend in a bar chart

avinashelite — Tue, 01 Mar 2016 12:26:44 GMT

I think you build the interval in the script rite? and you have used the same column in the front end

implement this expression in the dimension part where the interval column is used

if your 16 - 24 , 25 - 34 etc are stored in the column name A than use this condition in the dimension

Re: legend in a bar chart

udaya_kumar — Tue, 01 Mar 2016 12:37:22 GMT

Hi Chris,

May be you can try something like as shown in the attached image.

Re: legend in a bar chart

Tue, 01 Mar 2016 12:40:37 GMT

That would be great but how to you get the legend to transpose along the bottom?

Re: legend in a bar chart

stephenedberkg — Tue, 01 Mar 2016 12:45:14 GMT

Press the ctrl and shift key and drag the legend into bottom

and just adjust the legend box size