topic Re: Question on Chart background color in QlikView

Question on Chart background color

ramanarayan — Wed, 25 Nov 2020 16:16:04 GMT

Hi QV Experts,

I am finding it hard to get the color coding to work in one of the charts that i built. The background color does not seem to behave the same way how i wrote the expression for the background color. The colors are not in sync with the color expression.

Any reason for this behaviour?

Attached is my chart screen shot.

My chart should ideally reflect, RED, Blue, Yellow and Green color legends.

Thanks,

Ram

Re: Question on Chart background color

Clever_Anjos — Thu, 11 Jan 2018 10:38:42 GMT

Could you post your background color expression?

Easier to find out what is going wrong

Re: Question on Chart background color

ramanarayan — Thu, 11 Jan 2018 10:44:45 GMT

Thanks Clever Anjos for responding. Here is the expression.

=if(UTK_Fill_Rate='0 %',LightRed(),

if(UTK_Fill_Rate > 90/100,LightGreen(),

if(UTK_Fill_Rate < 80/100,Yellow(),RGB (0,150,214))))

Re: Question on Chart background color

Clever_Anjos — Thu, 11 Jan 2018 10:52:10 GMT

And which expression you have?

Re: Question on Chart background color

ramanarayan — Thu, 11 Jan 2018 10:53:55 GMT

The expression that i have at a chart level is the following

=count([FRCA_Fill Rate Category])

but the color coding is decided by another field. Is that the problem?

Re: Question on Chart background color

Anil_Babu_Samineni — Thu, 11 Jan 2018 10:57:18 GMT

If possible please share mockup application to test

Re: Question on Chart background color

Clever_Anjos — Thu, 11 Jan 2018 11:35:47 GMT

Try with

if (

count([FRCA_Fill Rate Category]) / count( total [FRCA_Fill Rate Category]) > 0.9, LightGreen(),

if (

count([FRCA_Fill Rate Category]) / count( total [FRCA_Fill Rate Category]) > 0.8, Yellow(),

RGB (0,150,214)

))

please make your adjustements