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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
thanhphongle
Creator II
Creator II

Put values in a tablechart in different colors

Hello Community

is there an command, how I can put a certain word in a color?

Example

I have a function

I want to create a table chart

I use Product as Dimension

My expression is

if(Price>=100000, 'Dont buy', 'Buy')

I want QV to show in a table chart in a red color 'Dont buy' and 'Buy' in a green color

I know there s the color command rgb()

Is it possible to combine it?

1 Solution

Accepted Solutions
sunny_talwar

Use a background expression for this expression

If(Price >= 100000, LightRed(), LightGreen())

View solution in original post

1 Reply
sunny_talwar

Use a background expression for this expression

If(Price >= 100000, LightRed(), LightGreen())