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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
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