Using visual cues on negative numbers

[Anonymous]

I have the following table in Qlikview which has a mixture of negative and positive numbers.  I am trying to use the visual cues to show numbers in red that are less than or equal to five and I also want it to show-1,-2,-3,-4 or -5 as red.

Is there a way to do this?

Thanks

Greg

[Anonymous]

I should also have said that the problem is that it is also showing anything less than -5 as red and I don't want it to do that

[hic]

I wouldn't use visual cues for this. Instead, I would use a color expression. See for example under Colors in charts.

A color expression is more flexible and can have nested if()-functions or a pick function.

HIC

[sunny_talwar]

Do you have a sample you can share here?

[Anonymous]

Thanks Henric

I'll try that.  But I'm not very good with functions.  I'm also already using the text color expression for the first column in the table.  What would be the best way to write the expression

Thanks

Greg