topic Same colors for same values in chart in QlikView

Same colors for same values in chart

Thu, 10 Dec 2009 20:01:21 GMT

Hi everyone,

I have a problem with colors in charts

I have multiple charts with different dimensions with same values and I need to show these same values in one color in all charts.

I try to use 'Persistent colors', but it's not work correct.

BR, Andris

Same colors for same values in chart

Anonymous — Thu, 10 Dec 2009 20:03:00 GMT

You have the same dimensions which needs to have the same color ... or the same color for specific values?

Same colors for same values in chart

Thu, 10 Dec 2009 20:08:28 GMT

Same color for specific value:

for example: 2 - red, 3- yellow, 4 -green

Same colors for same values in chart

Anonymous — Thu, 10 Dec 2009 20:13:18 GMT

if you know which charts contain which values you could predefine the colors ... but I guesse this is not what you want, because when adding a value this should automatically be given a color?!

Same colors for same values in chart

kji — Thu, 10 Dec 2009 20:13:34 GMT

Persistent colors will makes sure tha same value in the same field is always presented with the same color (determined by load order), however if the value appears in more than one field there is no easy way to achieve this. For a limited number of values i guess you could achieve this using colorexpressions if(field='A',Red(),if(field='B',Blue(),...

Same colors for same values in chart

Thu, 10 Dec 2009 20:23:38 GMT

Yes, I try this expressions too, but there was two results: nothing or all chart in black.

See in file charts: Mark 1 & Mark 2

Same colors for same values in chart

Fri, 11 Dec 2009 18:41:39 GMT

I found what was wrong.

Red(),Blue().. not work here

There must be used rgb() function