topic using visual cues for background colouring in QlikView

using visual cues for background colouring

Sun, 26 Feb 2012 07:00:58 GMT

Hi,

i am trying to use visual cues for background colouring.

I am unable to usebackground colouring in expression as it colours the labels as well.

The expression is something like count(abc)

while the expression for the background colouring is something like

if (count (abc) > count(xyz)

,red

,green )

I am unable to put this condtion in the visual cues, it doesn't work.

using visual cues for background colouring

Anonymous — Sun, 26 Feb 2012 12:57:07 GMT

Visual cues works only with constants, not with expressions. You can use attribute expression instead, they are much more flexible. Your expression will be somethig like this:
if (count (abc) > count(xyz)
, rgb(255,0,0)
,rgb(0,255,0))
Adjust the colors as you see it fit.

using visual cues for background colouring

jagan — Mon, 27 Feb 2012 06:09:54 GMT

Hi,

In visual clues you can use the expression like this

In Expression attribute you can use the following expression

if (count (abc) > count(xyz), Red(), Green() )

if(Count(abc) > Count(xyz), RGB(255, 0, 0), RGB(0, 255, 0))

Instead of using Visual clues, using the Expression Background attribute is more flexible.

Hope this helps you.

Regards,

Jagan.

using visual cues for background colouring

Tue, 28 Feb 2012 09:49:21 GMT

Thanks Jagan,

The issue with using expressions is that it colours the Lables (headers) as well.