Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Dinamic Colour in Line Chart

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

4 Replies
marcus_malinow
Valued Contributor III

Re: Dinamic Colour in Line Chart

Hi Anup,

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

Marcus

Not applicable

Re: Dinamic Colour in Line Chart

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

Not applicable

Re: Dinamic Colour in Line Chart

Hi,

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

Amay

singhpooja
Contributor III

Re: Dinamic Colour in Line Chart

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,