topic conditional formatting the output in QlikView

conditional formatting the output

Mon, 07 Feb 2011 13:58:35 GMT

I have some text as a header in a bar chart with an expression.
I would like for the result af the exp to change color if its over or under zero.

the expression is like this

left(sum(Gsnit2)-count(Journalnummer),4).

I tried something like this

if(left(sum(Gsnit2)-count(Journalnummer),4)<0,green,red)) but it doesnt work??

Mon, 07 Feb 2011 14:04:31 GMT

Hi,

When specifying colours, you need to use (). i.e. Green() or Red().

I hope this helps.

Thanks

Nick

brenner_martina — Mon, 07 Feb 2011 14:06:11 GMT

Hi,

you must use tho function Green() resp. Red() or RGB(255,0,0) and so on

Mon, 07 Feb 2011 14:28:44 GMT

I have tried like this

if(left(sum(Gsnit2)-count(Journalnummer),4)<0,green(),red())) but the output

come like this instead of the result RGB(0,128,0)) I want the number to be either red or green