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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get 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