Qlikview BG Expression

[sspawar88]

Hi,

Even i used Color Expression at background is

=if(Difference <=5,RGB(0,255,0),if(Difference >=6 and (Difference) <=15, RGB(255,128,0), RGB(255,0,0)))

Why Qlikview behave 380%  as Green?

[MK_QSL]

Try '5%' '6%' etc

[sunny_talwar]

Because 5 means 500% so anything below 500% is  colored Green.

What is your expectation?

[Chanty4u]

Did u try with  RGB instead of

Red(),

Green()

Yellow()  ?

and the diffrnce is too less. thats y its shwng lik dat

[Anonymous · Accepted solution]

Hi,

I think Qlik is doing exactly what you asked for.

In fact, your last colomn is in % so when u have 90.5%, it is corresponding to 0.905 which is <=5.

So you should change your expression to:

=if(Difference <=0.05,RGB(0,255,0),if(Difference >=0.06 and (Difference) <=0.15, RGB(255,128,0), RGB(255,0,0)))

[sspawar88]

All Value greater than & equal to 16 should be Red

Less than & Equal to 5 should be green and else should be Amber

[sspawar88]

Yes it is Correct.

But I'm not getting that things.

Because if i used that % In Expression then whatever the result in 'DIfference' should be mapping with BG expression.

why it consider seperate % ?

[sunny_talwar]

If those are your condition then the chart is working right. I am not sure what are you expecting the chart to show?