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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

how to use calculated color

i want to add visual cue to a simple text box background color ( red / green) what is the sintax for color?

if ( condition >=1,GREEN,RED)

1 Solution

Accepted Solutions
its_anandrjs
Champion III
Champion III

You can try like

GREEN( ) or RED( )

if ( condition >=1,GREEN( ),RED( ) )


Or


if ( condition >=1,RGB(0,128,128),RGB(255,0,0) )



View solution in original post

12 Replies
Not applicable

just say GREEN()

ilanbaruch
Specialist
Specialist
Author

THANK YOU

Not applicable

can you mark the thread as 'Answered'?

its_anandrjs
Champion III
Champion III

You can try like

GREEN( ) or RED( )

if ( condition >=1,GREEN( ),RED( ) )


Or


if ( condition >=1,RGB(0,128,128),RGB(255,0,0) )



sasikanth
Master
Master

OtherWise , you have a function

RGB( -,-,-)/ARGB(-,-,-,-)

by using these functions you can

ilanbaruch
Specialist
Specialist
Author

thanks, where can i find a color map or color list?

its_anandrjs
Champion III
Champion III

You can find color value like RGB in any color palate in the option color button in any chart from there if you select the colors you get the R,G,B values also Hue,Sat and Lum.

See the snap

Color Palate.png

sasikanth
Master
Master

hi ian,

Please find the attahment ,

there you can find the values ,

very usefull while working on color schemes

ilanbaruch
Specialist
Specialist
Author

thanks but what values i add to the syntax?