Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to integrate RGB expression in sum expression?

Hi,

I want to integrate the RGB expression in:

=Sum({$<timeline={'T-4','T-5','T-6','T-7'}>}values)

to have a black "RGB (0,0,0)" line in a line chart which is now automatically set to blue. How or where do I need to integrate the RGB expression?

Thanks

-Koper Nikus

1 Solution

Accepted Solutions
Not applicable
Author

Go to Expressions and under the color option

Captura.JPG

Write the expression you need, in this example

IF(CalendarYear<>vCurrentYear,RGB(255,0,0),RGB(0,255,0))

See the result

Captura.JPG

Hope this help

View solution in original post

3 Replies
rajni_batra
Specialist
Specialist

u can set this in calculated color under color tabcolor.png

Not applicable
Author

Well nearly perfect, but I want to give every single line in my line chart a special colour and two lines shall have the same colour. In the calculated colour I can not chosse a single line in my chart.

Not applicable
Author

Go to Expressions and under the color option

Captura.JPG

Write the expression you need, in this example

IF(CalendarYear<>vCurrentYear,RGB(255,0,0),RGB(0,255,0))

See the result

Captura.JPG

Hope this help