topic Re: multiples colores en bar chart in QlikView

multiples colores en bar chart

debcorne — Wed, 25 Nov 2020 16:16:04 GMT

Buenas Tardes,

Tengo un bar chart apilado con una dimensión con 198 valores posibles, y necesito cada valor que tome la dimesion no se repita.

Alguna Sugerencia?

Gracias

Re: multiples colores en bar chart

Gysbert_Wassenaar — Wed, 16 Nov 2016 18:31:43 GMT

Well, you can start mucking about the the RGB() and or ARGB() functions. Or define a color mapping table in for example excel with rgb values for each dimension value and load that table and use the rgb values that way. But realistically, nobody can distinguish 200 colors shown at the same time like that in a bar chart. A lot of colors will look very similar and practically cannot be distinguished from each other. Try to limit the number of dimension values shown. Perhaps you can group values or create some kind of hierarchy.

Re: multiples colores en bar chart

debcorne — Wed, 16 Nov 2016 18:36:20 GMT

TGysbert,

Entiendo tu consejo, la realidad es que estoy mostrando el top five de esa dimension y agrupando en otros el resto en OTROS, El problema que se navega por fechas y se repiten los colores para los distintos dias

e utilizado

Color(FieldIndex('Name',Name)) bitand RGB(245,255,255)

En la definicion de la expresion aun asi se siguen repitiendo los colores

Alguna otra sugerencia?

Re: multiples colores en bar chart

johnw — Wed, 16 Nov 2016 18:38:25 GMT

I don't think you'll be able to find 198 colors that are easily distinguished from each other. But you can certainly define 198 colors that are distinct.

Colors:
LOAD
Dimension
,rgb(R,G,B) as Color
INLINE [
Dimension,R,G,B
A,237,10,63
B,195,33,72
C,253,14,53
... for all your values ...
];

Then use Color as your background color expression.

You might, say, use the list of all Crayola colors, or any other long list of colors.

https://en.wikipedia.org/wiki/List_of_Crayola_crayon_colors#Standard_colors

Re: multiples colores en bar chart

Gysbert_Wassenaar — Wed, 16 Nov 2016 18:43:28 GMT

The problem with the Color() function is that there are only 20 colors. You can either create a color map that associates each dimension value with its own color. Or you need to create an expression that calculates a color using for example the rgb function and the fieldindex number of the dimension value.

Re: multiples colores en bar chart

johnw — Wed, 16 Nov 2016 18:53:20 GMT

marcowedel has script to pull in a large number of colors in this thread:Color by Expression