topic Font Colour Expression in QlikView

Font Colour Expression

Wed, 01 Apr 2015 08:38:51 GMT

Good Morning

Please could someone assist me with conditional colour formatting of text within a table.

The columns expression is

round(Sum (totalinvlinevalue*invnewproduct)/Sum (totalinvlinevalue),0.03)

What I require is that if the result is 15% or LESS text to be RED and if not GREEN.

Thank you

Emma

Re: Font Colour Expression

settu_periasamy — Wed, 01 Apr 2015 08:42:47 GMT

Try like the below screen shot

Re: Font Colour Expression

MK_QSL — Wed, 01 Apr 2015 08:43:20 GMT

IF(NUM(Sum (totalinvlinevalue*invnewproduct)/Sum (totalinvlinevalue),#0.00%)<='15%', RED(),GREEN())

Re: Font Colour Expression

Wed, 01 Apr 2015 08:44:15 GMT

Click on + sign in expressions under chart properties, then in Text Color update your condition. Something like this if(round(Sum (totalinvlinevalue*invnewproduct)/Sum (totalinvlinevalue),0.03)<=0.15,red(),green())

Re: Font Colour Expression

Wed, 01 Apr 2015 08:50:48 GMT

Manish

I get an error with this as

Bad field name #0.00%

Re: Font Colour Expression

Wed, 01 Apr 2015 08:52:36 GMT

Try '#0.00%' in commas

Re: Font Colour Expression

MK_QSL — Wed, 01 Apr 2015 08:53:17 GMT

IF(NUM(Sum (totalinvlinevalue*invnewproduct)/Sum (totalinvlinevalue),'#0.00%')<='15%', RED(),GREEN())

Re: Font Colour Expression

Wed, 01 Apr 2015 08:58:26 GMT

I have tried this and its states expression ok - however all my text is red - even over 15 ?

Re: Font Colour Expression

Wed, 01 Apr 2015 09:00:10 GMT

I have input as 0.15 and it is working perfectly

THANK YOU TO YOU ALL

Re: Font Colour Expression

Wed, 01 Apr 2015 09:01:16 GMT

thanks for all your help and support