Conditional Formatting/Visual Cues

[#1]

I'm using QlikView v12 and I have a straight table and I've applied Visual Cues to x2 columns containing numeric values.  If the value in the right column is higher than the value in the left column then the value should be in red.  Where the value in the right column is higher, in some cases the value is in red, however in other cases the value isn't shown in red.

The values are all in a range between 1 - 100 and as they are all in the same column the data type is the same, so I'm a little confused as to why the Visual Cues expression works for some values which are higher but not for other values (which are also higher).

Here is the syntax I'm using:

Avg({<MonthNum = {$(=Max(MonthNum)-2)}>}ReportTimeInSeconds) 

Any suggestions on how best to investigate this issue?

Thanks in advance.

[felipedl]

Hi Chris,

See if the attached QVW suits your needs.

I used the formatting ont he expression, instead of the Visual Cues

Felipe