topic Re: Condition Color Coding in QlikView

Condition Color Coding

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

Hi All,

Here I'm trying to achieve color coding based on three conditions. Have the fields Sum(Actual) & Sum(Forecast). Need to color code text in Sum(Actual) based on the below conditions:

If, Actual +/- 10 of the Forecast = Green

Actual +/- 11 to 25 of the Forecast = Blue

Actual +/- 26 and greater of the Forecast = Red.

Thanks for your help.

Re: Condition Color Coding

boorgura — Tue, 10 Apr 2018 20:17:51 GMT

You will have to give the expression in either the Text Color or Background color depending on your requirement.

IF(fabs(sum(actual)-sum(forecast)) <= 10, green(),

IF(fabs(sum(actual)-sum(forecast)) <= 25, blue(),

red()))

Re: Condition Color Coding

sergio0592 — Tue, 10 Apr 2018 20:39:09 GMT

As background color, try with :

=if(sum(Actual)-sum(Forecast) <=10 and sum(Actual)-sum(Forecast)>=-10 , green(), if(sum(Actual)-sum(Forecast)<=25 and sum(Actual)-sum(Forecast)>=-25, blue(),red()))

Re: Condition Color Coding

rxp03570 — Tue, 10 Apr 2018 20:41:01 GMT

Works Perfectly, Thanks!!!

Re: Condition Color Coding

rxp03570 — Tue, 10 Apr 2018 20:41:20 GMT

This one works as well, Thanks!!!