topic Re: Removing values from legends in QlikView

Removing values from legends

Tue, 30 Jul 2013 13:55:45 GMT

I have a bar chart where i dont want some legends to be displayed and their respective value in bar graph.
How do i remove that legend?

Re: Removing values from legends

shree909 — Tue, 30 Jul 2013 14:16:59 GMT

Hi,

When u goto the properties of a barchart, select the tab expressions

in the tab at the extreme bottom right u find the option "expression as legend"

when u uncheck that u wont find the legends.

if u dont want to show the valueson the bar chart on the same tab

"uncheck the values on datapoints"

Hope this helps

Thanks

Re: Removing values from legends

Tue, 30 Jul 2013 14:25:11 GMT

Hi Hitesh,

You can go to properties of Bar chart and select Dimensions .After selecting the particular dimension you can uncheck the legend button for the same.Legend will disappear from the chart.

For Value Select Expressions from properties and uncheck the Values on Data Points button.

Hope this helps.

Thanks,

Vaneet

Re: Removing values from legends

Wed, 31 Jul 2013 04:36:27 GMT

Hi guys,

You misunderstood the question...

i dont want some legends from list of legends.

example:

suppose there are 5 legends (a,b,c,d,e)

from this list i dont want a and b to be displayed on bar graph.

Re: Removing values from legends

er_mohit — Wed, 31 Jul 2013 05:28:39 GMT

in dimension side you have to write like this way

=if(Match(fieldname,'a','b'),Null(),fieldname)

make sure check on supress null value and write the actual name of field in label side