topic Disappearing Lable Color in Bar Chart in QlikView

Disappearing Lable Color in Bar Chart

Fri, 27 Sep 2013 08:51:03 GMT

Hi All

I have a bar chart where the label color is disappearing to be transparent.

I dont know how to solve this. Does anyone know how to solve this problem? If I make a selection the color become visible again.

I am happy for any help.

Re: Disappearing Lable Color in Bar Chart

tresB — Fri, 27 Sep 2013 08:56:38 GMT

Could you share your app sample?

Re: Re: Disappearing Lable Color in Bar Chart

Fri, 27 Sep 2013 09:34:59 GMT

I have attached the file with the graph where the color that is Disappearing. I have added background color that depends on the selection. If a selection is made the the label is showing the color for the largest selection. But if no selection is made the label is not showing any color at all.

Re: Re: Disappearing Lable Color in Bar Chart

Fri, 27 Sep 2013 09:39:51 GMT

Thanks. I have included the graph now. I am new with Qlikview so I forgot to add a sample file. I think it has to do with the background color expression that I have added. But yesterday the color for the labels did disappear as well when I didnt have a background color expression in the graph.

Re: Disappearing Lable Color in Bar Chart

Fri, 27 Sep 2013 09:42:32 GMT

File doesn't contain data for the date of 7 and 11..

Thats why it doesn't show bar...

If you don't want to show that emty value.. then check on Suppress Zero Values (Properties --> Presentation --> Suppress Zero Values)

and un check on Show all Values (Properties - -> Dimension)

Karthik

Re: Disappearing Lable Color in Bar Chart

jonathandienst — Fri, 27 Sep 2013 09:55:29 GMT

The problem is that your colour expression is only valid if 1 OpportunityMonth value is selected. See bold below:

=if(GetPossibleCount(OpportunityMonth)<>count({1}distinct Total OpportunityMonth),

if(match(OpportunityMonth,concat(distinct OpportunityMonth,',')),

rgb(138,138,138),

argb(250,192,192,192)))

This expression can't be evaluated if more than one OpportunityMonth is possible. If you select one month, then it will work. I am not sure what result you are aiming for with this logic.

Regards

Jonathan

Re: Disappearing Lable Color in Bar Chart

Fri, 27 Sep 2013 09:57:08 GMT

I want to have the record there where there is no value. The label color is disappearing, I have tried to uncheck check the Suppress Zero Values and Show all Values and this does not affect if the label colors are showing or not.

Re: Re: Re: Disappearing Lable Color in Bar Chart

tresB — Fri, 27 Sep 2013 10:12:18 GMT

Indeed, it was because of the calculated bkground color. I removed that and see now it is working fine. PFA

Re: Disappearing Lable Color in Bar Chart

Fri, 27 Sep 2013 10:48:56 GMT

Yes but I want the calculated background color since it is changeing the color on the nonselected records to be more light.

Re: Disappearing Lable Color in Bar Chart

Fri, 27 Sep 2013 10:50:01 GMT

The expression is changing the color on the bars that are not selected if you make a selection.