background color condition not working Qlik view

[Purushothaman]

Hi Experts,

I am facing error with background condition, Below is the image and attached is my QVW.  My Condition is:

IF year sale is less than or Equal to 500000 then Green else Red. but all the rows are showing red. 

Pleas help me. Thank you,

[sergio0592]

Hi,

I think your field is not recognized as number. Try to use num#() in your loading statement.

[marcus_sommer · Accepted solution]

Try it with:

if(sum(Sales) <= ....

- Marcus

[Purushothaman]

@marcus_sommer  Thank you, Its working now.