topic Re: Change in colour depending on values in QlikView

Change in colour depending on values

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

Hello All,

I have a requirement wherein I need to compare the Failed Count YTD(FCY) column value with 2017 Target value. If the FCY value is greater than the 2017 target, it should be highlighted as green, else red. The table I am using is a straight table. And this comparison should happen across all the products listed.

Any suggestions ?

Product	2016	Failed Count YTD	2017 Target	2017 Stretch Target
A	1.10%	1.8%	1.00%	0.80%
C	3.00%	2.4%	2.25%	1.50%
D	5.60%	2.4%	4.20%	2.80%
E	0.00%	2.4%	0.00%	0.00%
F	0.00%	2.3%	0.00%	0.00%
G	0.00%	2.2%	0.00%	0.00%
H	0.30%	2.1%	0.23%	0.15%
I	0.00%	2.3%	0.00%	0.00%
J	0.30%	1.9%	0.23%	0.15%

Re: Change in colour depending on values

PrashantSangle — Wed, 06 Sep 2017 11:53:29 GMT

Hi,

Expand expression > Background color > write expression for color like

if(FCY_expression > 2017 target,green(),yellow())

regards,

Re: Change in colour depending on values

its_anandrjs — Wed, 06 Sep 2017 11:54:22 GMT

In the Backcolor properties try

=if( Sum( TOTAL FCY) > Sum( TOTAL 2017 Target) ,Green(), Red())

Re: Change in colour depending on values

its_anandrjs — Wed, 06 Sep 2017 11:56:55 GMT

Expand the chart properties of Product dimension from here and then write

=if( Sum( TOTAL FCY) > Sum( TOTAL 2017 Target) ,Green(), Red())

=if( Sum( FCY ) > Sum( 2017 Target) ,Green(), Red())

Re: Change in colour depending on values

florentina_doga — Wed, 06 Sep 2017 12:14:03 GMT

or use visual cues on 2017 Stretch Target

>1 green()

Re: Change in colour depending on values

oscar_ortiz — Wed, 06 Sep 2017 19:15:45 GMT

Joshua,

If you are not using dynamic labels you can use the column labels in your color expression. Something like:

If( [Failed Count YTD] > [2017 Target], LightGreen(), LightRed() )

Good luck

Oscar

Re: Change in colour depending on values

florentina_doga — Thu, 07 Sep 2017 14:27:02 GMT

see attach