topic Re: Common Line colours between graphs in QlikView

Common Line colours between graphs

samuel_brierley — Thu, 23 Jan 2014 14:19:40 GMT

Hi,

is there a way to make the line graphs use the same colours to represent a certain field.

just to make myself clear as i dont think that is,

I have 2 graphs one has date and contract as the dimensions and hours worked as the expression.

the other has the same dimensions but the expression is hours worked*Rate to give income.

the problem is a contract on one graph may be represented by a blue line on one graph and a yellow one on the other.

just abit of a pain to analyse, any ideas?

jvishnuram — Thu, 23 Jan 2014 14:27:28 GMT

Hi Samuel,

You need to check the persistent color option in the chart properties for both the charts.

samuel_brierley — Thu, 23 Jan 2014 14:30:15 GMT

thank you

magavi_framsteg — Thu, 23 Jan 2014 14:33:43 GMT

Samuel,

You can give an expression for the background color on the expression itself.

So the color expression for hours worked is always RGB(0,0,255).

And the color expression for worked*Rate is always RGB(0,128,128).

Using persistent colors does not always solve the problem, since you can have several objects with the same expressions rendering different colors.

Kind regards

BI Architect Consultant