Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Visual cues not working

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.

Tags (2)
1 Solution

Accepted Solutions
Partner
Partner

Re: Visual cues not working

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

2 Replies
Partner
Partner

Re: Visual cues not working

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

Not applicable

Re: Visual cues not working

Hi Simen,

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

Appreciate it!

Gayan.