topic Re: Dinamic Colour in Line Chart in QlikView

Dinamic Colour in Line Chart

Wed, 11 Feb 2015 08:47:54 GMT

Hello Guys,

I have a line chart in which two dimenssions are there and one expression is there. Two dimenssion is Date & Company name. I show in this graph date wise sale for the company. So I get multiple line for the company.

In my data model I have a Colour coding table in which two fields are there one is Company Name & second one is RGB() value.

Ex:

CompanyName,Colour

AAA,RGB(0,0,0)

BBB,RGB(230,74,14)

etc....

So in the sale expression background option I just put the field 'Colour' but the colour is not changed.

How can I maintain the colour for company through the different file.

Thanking You

regards

Anup

Re: Dinamic Colour in Line Chart

marcus_malinow — Wed, 11 Feb 2015 08:50:31 GMT

Hi Anup,

Try changing the Expression Background Colour to '=Only(Colour)'

Marcus

Re: Dinamic Colour in Line Chart

Wed, 11 Feb 2015 08:53:01 GMT

Thanks Marcus fir your reply. But it's not working.

Re: Dinamic Colour in Line Chart

Wed, 11 Feb 2015 10:12:38 GMT

Hi,

You can use nested if's in the expression background color to change it according to your dimension.

Amay

Re: Dinamic Colour in Line Chart

Anonymous — Fri, 07 Oct 2016 05:48:35 GMT

go to Expression -->expand your expression--> select background color--> give RGB() value according to your preferred color. same steps you can use for next expression also.

Thanks,