Color Expression

[sanjujeeboy]

Hi Team,

I have a table as shown below. I have shown only 2 countries. (There are more than that)

Country	Metric	Jan	Feb	Color Indicator
USA	Revenue	0.21	-0.18
Germany	Revenue	0.34	0.22

Looking at latest month, if my revenue is +ve color should be green, if -ve then red.

what should i write in color expression in qliksense

Thanks

[Yoshidaqlik]

Hi

try:

if(sum(Revenue)>=0, Green(),Red())

regards