Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
carolin01
Luminary Alumni
Luminary Alumni

Background colors for expression

Hello,

I defined the background colors of one of my expressions in my chart as follows:

If([Pareto Class] = 'C', LightRed(), If([Pareto Class] = 'B', LightBlue()))

Now I wonder if I could adjust the color by the following values:

Hue: 140

Sat: 240

Lum: 163

Red: 91

Green: 173

Blue: 255

This would really help me as I´ve a color blind colleague and we agreed on specifc colors that he can see.

Best regards,

Carolin

1 Solution

Accepted Solutions
Not applicable

Hi,

Yes you can convert it using RGB(). Do you want to use the colors you have mentioned instead of LightRed() and LightBlue() respectively then might be something like this would help:


If([Pareto Class] = 'C', RGB(140,240,163), If([Pareto Class] = 'B', RGB(91,173,255)))

View solution in original post

5 Replies
Not applicable

use rgb function:

ex:

If([Pareto Class] = 'C', rgb(91,173,255),red())



Hope this helps

its_anandrjs

Hi,

Create a inline table

load * Inline

[

Red,Green,Blue

91,173,255

];

and use this value in RGB( ) function

If([Pareto Class] = 'C',RGB(Red,Green,Blue), red())

You can create a Variables for this also.

Thanks & Regards

Not applicable

Hi,

Yes you can convert it using RGB(). Do you want to use the colors you have mentioned instead of LightRed() and LightBlue() respectively then might be something like this would help:


If([Pareto Class] = 'C', RGB(140,240,163), If([Pareto Class] = 'B', RGB(91,173,255)))

carolin01
Luminary Alumni
Luminary Alumni
Author

Thank you, this worked

its_anandrjs

Hi,

Other wise write some thing like this

load * Inline

[

Red,Green,Blue,Hue,Sat,Lum

91,173,255,140,240,163

];

and use this value in RGB( ) function

If([Pareto Class] = 'C', RGB(Red,Green,Blue), If([Pareto Class] = 'B', RGB(Hue,Sat,Lum) )

Thanks & Regards