topic Re: Qlikview BG Expression in QlikView

Qlikview BG Expression

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

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 — Mon, 04 Apr 2016 10:36:58 GMT

Try '5%' '6%' etc

sunny_talwar — Mon, 04 Apr 2016 10:37:03 GMT

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

What is your expectation?

Chanty4u — Mon, 04 Apr 2016 10:37:58 GMT

Did u try with RGB instead of

Red(),

Green()

Yellow() ?

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

Anonymous — Mon, 04 Apr 2016 10:39:32 GMT

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 — Mon, 04 Apr 2016 10:40:05 GMT

All Value greater than & equal to 16 should be Red

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

sspawar88 — Mon, 04 Apr 2016 10:43:44 GMT

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 — Mon, 04 Apr 2016 10:45:51 GMT

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