Conditional Formatting/Visual Cues

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Conditional Formatting/Visual Cues

felipedl — Thu, 17 Aug 2017 18:36:25 GMT

Hi Chris,

See if the attached QVW suits your needs.

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

Felipe

topic Conditional Formatting/Visual Cues in QlikView

Conditional Formatting/Visual Cues

Re: Conditional Formatting/Visual Cues