topic Re: text color Expression help? in QlikView

text color Expression help?

Mon, 26 Jan 2015 17:06:25 GMT

Hi,

I'm trying to create an expression, in an expression text color, to turn different colors when certain conditions are met.

If a single record of [Expression1] is 0 then Red,

And/Or

If 2 or more records of [Expression2] are 0 then red,

If Sum([Expression1]+[expression2]+[expression3]...] >= 20 then Green

else black

I can't figure out the syntax on this one. Could someone please help?

Thanks in advance.

Brian

Re: text color Expression help?

NickHoff — Mon, 26 Jan 2015 17:17:23 GMT

Can you be more specific on your current expressions? Also, the type of chart you are using?

Re: text color Expression help?

Mon, 26 Jan 2015 17:29:04 GMT

Thanks for the reply, Nick,

The expression I want to place this text color expression into is a simple expression where it adds all of the expression ‘scores’ of the table into a total. Each expression in the table is basically an if statement for scoring system. For example if Test Score1 >=.85, 4, 0; if Test Score2 >.9,5,0…etc) The Total Score expression just adds the expressions up to a total score. The total score expression is where I need to add the text color expression.

Re: text color Expression help?

NickHoff — Mon, 26 Jan 2015 17:40:02 GMT

IF(COUNT(TestScore1 = 1) AND TestScore1 > .85, Red()),

IF(COUNT(TestScore > 1) AND TestScore2 > .9, Red()),

IF(SUM([Expression1]+[Expression2]+[Expression3]) >= 20, Green()),

Black())