topic visual clues in QlikView

visual clues

Mon, 02 Nov 2009 17:35:30 GMT

Hi,

In visual clues i am not able to set the colors based on expressions.

Like if i want to highlight measure1 in green,if it is greater than measure2,eventhough i write a exopression in visual clues only one color is comming..................i want it to be done in visual clues itself and not in the expression for the background color under expressions tab.

pLEASE HELP.

Thanks in advance.

visual clues

kji — Mon, 02 Nov 2009 18:53:57 GMT

Visual cue vales that are expressions, are not calculated for each row of data, but for the current state of your selections so you can only use to relate different column values. To do comparisons row by row you would have to use the Text Color subexpression on your expressions.

visual clues

Mon, 02 Nov 2009 18:54:01 GMT

Hi,

I hope it will work.Better you try in Expression part instead of trying in Visual Cues

visual clues

Mon, 02 Nov 2009 19:46:51 GMT

Try below expression tos how different colors for matching criterias:

=IF(sum(Sales) >= sum(Budget), green(), red())