Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

using visual cues for background colouring

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.

3 Replies
Anonymous
Not applicable
Author

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.

jagan
Partner - Champion III
Partner - Champion III

Hi,

In visual clues you can use the expression like this

2.GIF

In Expression attribute you can use the following expression

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

OR

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

1.GIF

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

Hope this helps you.

Regards,

Jagan.


Not applicable
Author

Thanks Jagan,

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