Visual cues not working

[#1]

Hi,

I have a table which displays a percentage (let's call it Target) for each record. A given record has a defined benchmark percentage and I intend to highlight the calculate the Target and highlight in red or green. Can I do this using the visual cues feature?

I'm a newbie to Qlikview so any help is appreciated.

Thanks,

Gayan.

[simenkg · Accepted solution]

Hi Gayan.

The Visual Cues tab sets the limits for the whole table.

If each row/record has a different Target, this is how you do it.

On the expression tab, expand your expression by clicking the + sign next to it.

Depending on whether you want to highlight it with text color or background color double click the corresponding line.

The expression would look something like this.

if(Sum(Amount)>Target,Green(),Red())

[#3]

Hi Simen,

Thank you for the help given! It worked like a charm!

Appreciate it!

Gayan.