Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
ramanarayan
New Contributor III

Question on Chart background color

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.

Capture.PNG

Thanks,

Ram

Tags (1)
6 Replies
Employee
Employee

Re: Question on Chart background color

Could you post your background color expression?

Easier to find out what is going wrong

ramanarayan
New Contributor III

Re: Question on Chart background color

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))))

Employee
Employee

Re: Question on Chart background color

And which expression you have?

ramanarayan
New Contributor III

Re: Question on Chart background color

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

If possible please share mockup application to test

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Employee
Employee

Re: Question on Chart background color

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