topic Re: same Colour on a bar charts in QlikView

same Colour on a bar charts

andyrebs — Thu, 11 Dec 2014 17:09:22 GMT

Dear All,

I have have a problem in a representation of a bar chart. As you can see on the image, two values have the same colour. Why it happen, how can I solve this problem?

Thank you in advance.

Best regards

Andrea

Re: same Colour on a bar charts

MK_QSL — Thu, 11 Dec 2014 17:12:42 GMT

Go to Chart Properties

Color Tab

and Change the Colors 1-6 and Colors 7-12 according to your need.. Make sure no two colors are same

Re: same Colour on a bar charts

rwunderlich — Thu, 11 Dec 2014 17:20:24 GMT

You probably have "Persistent Colors" checked on the Colors tab?

-Rob

Re: same Colour on a bar charts

andyrebs — Thu, 11 Dec 2014 17:40:25 GMT

Thank you Rob for your answer.

Yes,"PERSISTENT COLORS" is checked, but I would keep it checked, because it is helpful on the selections.

Re: same Colour on a bar charts

andyrebs — Thu, 11 Dec 2014 17:44:58 GMT

Thank you Manish

I have checked, there are no duplicate colours

Re: same Colour on a bar charts

rwunderlich — Thu, 11 Dec 2014 23:20:23 GMT

A side effect of "Persistent Colors" is that you may get colors duplicated on a chart, even with less than 18 values shown on a chart. When Persistent Colors is checked, QV pre-assigns colors to all values in the field in load order. If you have more than 18 values in the field, the assignment just rotates through the same 18 colors again. So value 19 will have the same color as value 1.

-Rob

Re: same Colour on a bar charts

andyrebs — Fri, 12 Dec 2014 08:58:09 GMT

hi Rob

thank you for your clarification. Because in the field there are more than 10.000 values, I think there are many case to find same colour for different values. Is there any possibilities to set more than 18 colours or the only solution is to uncheck "Persistent colour"?

best regards

Andrea

Re: same Colour on a bar charts

rwunderlich — Fri, 12 Dec 2014 19:33:35 GMT

The persistent color option only supports 18 colors. You could pre-assign colors yourself using a larger set of colors, but you still may have some duplicates.

-Rob