topic Visual cues not working in QlikView

Visual cues not working

Fri, 01 Aug 2014 13:19:01 GMT

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.

Re: Visual cues not working

simenkg — Fri, 01 Aug 2014 13:41:50 GMT

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())

Re: Visual cues not working

Fri, 01 Aug 2014 13:51:48 GMT

Hi Simen,

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

Appreciate it!

Gayan.