topic Re: Question about colors in chart in QlikView

Question about colors in chart

Thu, 12 Jul 2012 13:25:50 GMT

Hello,

At the tab Colors (Chart Properties) is the option 'persistent colors'.

If I do not use this option my chart looks as folow and the colors are according default data appearance color 1-6.

If I use the option my Chart looks as follows and the colors colors are not according data appearance color 1-6.

Even one color pops up twice (first and last in chart).

Questions:

1. Why if I use the option 'persistent colors' the colors are not according to the default data appearance color 1-6.

2. How to handle that the colors are according to the default data appearance color 1-6, or how can I ssign colors.

Any ideas?

Regards,

Gerrit

Re: Question about colors in chart

Thu, 12 Jul 2012 13:34:25 GMT

try sort your dimension by load order

Re: Question about colors in chart

Thu, 12 Jul 2012 13:43:59 GMT

I tried but no change in the color scheme.

Part of my script looks as follows.

Maybe there is a clou?

MAINTABEL:

LOAD

'DGI' as Bedrijf,

"Posting Date" as DATUM,

"Entry Type",

"Location Code",

IF ("Location Code" = 'COR-RETOUR', 'HEDEL', "Location Code" ) As Vestiging,

"Document Type",

Re: Question about colors in chart

Thu, 12 Jul 2012 13:48:22 GMT

i've check my hint and:

- if i get sort order : load order

colors are the sam as in persistant color and in default data appearance color 1-6

for 100%

Re: Question about colors in chart

Thu, 12 Jul 2012 13:56:22 GMT

I have cheked your hint and:

in my chart colors are not the same as in persistant color and at not in default data appearance color 1-6

for 100%

Re: Question about colors in chart

Thu, 12 Jul 2012 14:01:09 GMT

can you send a qvw file?:)

Re: Question about colors in chart

Thu, 12 Jul 2012 15:19:09 GMT

The strange behavior is displayed only when a mass of data is loaded.

I will attach the qvw with a limited dataset, but in this case, the phenomenon does not occur.

Can't send you more because the data is confidential.

Be aware the sheet is not finished yet.

Re: Question about colors in chart

Thu, 12 Jul 2012 15:40:47 GMT

it looks like if you mark "persistant color" qv takes all the passible dimension value and link them to the color 1-6-12-18 (not only these from actual selection)

got it? (my english is terrific:P)

Re: Question about colors in chart

kji — Thu, 12 Jul 2012 15:48:20 GMT

Persistent Colors will match colors with Field Values so that the same Value will always have the same color in the chart. The matching is based on load order, so that the first Value that is found when doing a reload will be using color 1, the second color 2 and so on. This might lead to colors repeating even if there are fewer values than the size of the color palette.

When not using Persistent Colors it assigns colors i the order the values occurs in the chart, which will match different colors to values depending on selections, it does however make it so that as long as the number of values is less than the size of the color palette you will not repeat a color.

Re: Question about colors in chart

Thu, 12 Jul 2012 21:43:23 GMT

Thanks, I can now see the logic.

Re: Question about colors in chart

Thu, 06 Aug 2015 14:39:04 GMT

"This might lead to colors repeating even if there are fewer values than the size of the color palette."

So in that case persistent colour wouldnt be very helpful, or is there a way to avoid such thing?

Re: Question about colors in chart

Fri, 20 Nov 2015 11:57:00 GMT

Hi Johan,

I want to assign always the same colour to each attribute within a dimension;

Imagine I have 100 attributes in the dimension (AA). When I use the dimension in a graph, Qlikview shows different colours for each attribute automatically (by selecting the multicolored option). I can mark these colours as persistents for the next graphs. (I haven't had any problem with that)

The point is that I only want to analyze 2 attributes, with 2 different expressions in a graph. In so doing, QlikView assigns the first two colours of the scale (blue and red), in stead of those used before for this two attributes.

For resolving this issue, I have created a .xlsx where I've specified the name of the attribute and its GRB colour (xx,xx,xx). (I actually don't know if i can do it this way)

I really appreciate any information you may provide.

Thank you!

Cheers,

Pedro.