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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to give the colors to the column values

Hi,

I like to give the color to the values in a particular column depending on the values in them...

for example if the sum(sales)>100 it should show the values in green color background

less than < 100 ,red color to be displayed

pls explain in detail if possible with screenshots..

pls,,help me out,,thanks in advance

2 Replies
Not applicable
Author

Hi btechrames,

Please see attached image

I used this code in the background (See circled in image)


If(Sum(Sales) > 100, RGB(0,255,0), RGB(255,0,0)


Not applicable
Author

Hi,

go to the Visualcues tabs-->set the upper boundary as 100 and set the color as green beside of the that expression area and set the lower boundary as 50 and set the color as red .