topic Background Color? in QlikView

Background Color?

Anonymous — Wed, 22 Feb 2017 14:33:41 GMT

Hi,

I have an expression and will like to add a background color based on the result of that expression. How can I do it?

I mean I need that the field is set to Red if value is higher than 0.5 and green if it's lower than 0.5.

Please advise.

Re: Background Color?

Anil_Babu_Samineni — Wed, 22 Feb 2017 14:36:07 GMT

Try like below from your background color of your expression.

If(Field > 0.5, Red(), If(Field < 0.5, Green())

If(Field>0.5, Red(), Green())

Re: Background Color?

Anonymous — Wed, 22 Feb 2017 14:41:38 GMT

I mean, the expression is a field calculated that is a percentage, what should be the field that I should use? or it will works if I use the name of the expression?

Re: Background Color?

sunny_talwar — Wed, 22 Feb 2017 14:52:07 GMT

I think you need to use the whole expression or you can use expression label

Re: Background Color?

Anonymous — Wed, 22 Feb 2017 15:08:07 GMT

Ok, something is not working.

I want to have all the pair months on grey, but also will like to have an specific color the expression is higher than 0.5 and another one if the expression is lower than 0.5.

This is what I am trying:

if (mod(Month,2)=0, RGB(128,130,133)) or if ([Escalation Request Rate] > 0.05, RBG('RED'), RGB (Green))

What am I doing wrong?

Re: Background Color?

Anil_Babu_Samineni — Wed, 22 Feb 2017 15:21:37 GMT

May be this

Here i am assuming month is in Number format

if (mod(Month,2)=0, RGB(128,130,133) or [Escalation Request Rate] > 0.05, RED(), Green())

if (mod(Month,2)=0, RGB(128,130,133),If(Sum([Escalation Request Rate]) > 0.05, RED(), Green()))

Re: Background Color?

sunny_talwar — Wed, 22 Feb 2017 15:26:10 GMT

Is [Escalation Request Rate] your expression or expression label here?

Re: Background Color?

Anonymous — Wed, 22 Feb 2017 15:34:13 GMT

Yes, Escalation Request Rate is a field that will display percentage, however the expression is not working.

I have removed the first part if (mod(Month,2)=0, RGB(128,130,133)

But I am still not getting the right colors.

if ([Escalation Request Rate] > 0.05, RED(), Green())

I am seeing records in green where Escalation Request Rate is higher than 0.5%

Re: Background Color?

sunny_talwar — Wed, 22 Feb 2017 15:35:14 GMT

Would you be able to share a screenshot of your chart and your background expression?

Re: Background Color?

Anonymous — Wed, 22 Feb 2017 15:42:19 GMT

The background expression is if ([Escalation Request Rate] > 0.05, RED(), Green())

As you can see the first 6 records are OK, but the seventh is not.

Re: Background Color?

Anil_Babu_Samineni — Wed, 22 Feb 2017 16:13:12 GMT

Try some thing like below

If(Num(sum([Escalation Request Rate]),'#,##0.00%')>Num('0.05%'), Red(), Green())

If(sum([Escalation Request Rate])>Num('0.05%'), Red(), Green()) //Here, You should go to number tab and fixed it to % with Fixed To Two decimals for

Re: Background Color?

Anonymous — Wed, 22 Feb 2017 17:05:29 GMT

That's weird, still not working.

Re: Background Color?

sunny_talwar — Wed, 22 Feb 2017 17:07:19 GMT

Would you be able to share a sample?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Re: Background Color?

Anonymous — Wed, 22 Feb 2017 17:14:32 GMT

I cannot share it, but I won't use the background colors then, thank's all for their efforts.

Re: Background Color?

Anil_Babu_Samineni — Wed, 22 Feb 2017 17:27:18 GMT

Are you expecting this in Listbox?

but I won't use the background colors then, .

What does that mean? Where you are trying this?

Re: Background Color?

tcullinane — Wed, 22 Feb 2017 17:27:33 GMT

Is [Escalation Request Rate] a numeric or text field? You should make sure it is numeric (possibly wrap it in a dual to create numeric part)

Also 0.69% is less that 5%, so perhaps you should use 0.005 as you cut off point.

Re: Background Color?

Anonymous — Wed, 22 Feb 2017 18:46:20 GMT

You're right Thomas, I am using if ([Escalation Request Rate] > 0.05, RED(), Green()) , so 0,69% should be lower than 0,05 or am I wrong?

Also, in the expression's section I have the Escalation Request Rate like text representation, but I am not seeing any other type that I can use as number or something like that.

Re: Background Color?

Anonymous — Wed, 22 Feb 2017 20:19:50 GMT

No, I expected this in a Straight table, but for some reason the expression in the background color is not working.

Re: Background Color?

tcullinane — Thu, 23 Feb 2017 10:49:37 GMT

So why is it incorrect that it is green in you above example?

To check that your field is actually numeric go to the number property tab in your straight table and untick show in % on the [Escalation Request Rate] field or change the decimal places shown.

Re: Background Color?

sumitjadhav — Thu, 23 Feb 2017 11:24:14 GMT

Try the below expression:

if([Escalation Request Rate]>5/100,Red(),Green())