topic Re: How to integrate RGB expression in sum expression? in QlikView

How to integrate RGB expression in sum expression?

Wed, 19 Sep 2012 10:30:10 GMT

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

Re: How to integrate RGB expression in sum expression?

rajni_batra — Wed, 19 Sep 2012 10:39:52 GMT

u can set this in calculated color under color tab

Re: How to integrate RGB expression in sum expression?

Thu, 20 Sep 2012 10:32:37 GMT

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.

Re: How to integrate RGB expression in sum expression?

Thu, 20 Sep 2012 13:45:33 GMT

Go to Expressions and under the color option

Write the expression you need, in this example

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

See the result

Hope this help