topic Visual Cues in QlikView

Visual Cues

Fri, 20 Nov 2009 04:21:49 GMT

I have a pivot table with two dimensions. Business Units and Location. The Business Units are down the side and the Locations are across the top. Its a matrix chart. How do I show a visual cue of my expression displaying the highest value for each location in green and the lowest value for each location in red? So I want it to read the highest value in Location X will be in Green for Business Unit Y. Essentially there will be a green and red value for each location. Any help would be apprecaited. Thanks.

Visual Cues

Fri, 20 Nov 2009 04:31:32 GMT

Sounds to me you can't use Visual Cues for this. You can however use the Background Color in the Expressions. Click on the + before an expression, then select the Background Color. Now you can use an expression in the Definition field to set the colors.

You probably want to use Max() and Min() to set the colors. Colors are set using the RGB() function.

Hope this helps 🙂

Visual Cues

prieper — Fri, 20 Nov 2009 04:32:53 GMT

You may open the small "+" below the expression and enter your conditions as background-colour, e.g.

IF(SUM(Val) = MAX(SUM(Val)), LIGHTGREEN(), IF(SUM(Val) = MIN(SUM(Val)), LIGHTRED())

HTH
Peter