topic Block chart color assignments in QlikView

Block chart color assignments

Tue, 13 Mar 2012 16:50:09 GMT

I am trying to set colors in a block chart. I want Company A to be blue, Company B to be green and so on.

I see that you can use if statements however this only gives you a dark shade of the color. Is it possible to pick the the exact color ie RGB (141,90,172)

= if(Catebgoryl='Fuinancial',Green(),Green())

=if(Category='Documentation',Red(),Red())

=if(Category='Other',Yellow(),Yellow())

Block chart color assignments

Tue, 13 Mar 2012 17:54:32 GMT

Yes you can use RGB values, its very close to what you have:

Only rather than using color functions, just write in the RGB values.

e.g.

= if(Category='Documentation',RGB(45,127,89),RGB(45,127,89)) for the first color block for 1-6

= if(Category ='Other',RGB(141,90,172),RGB(141,90,172)) for the second color block for 1-6 and so on...

Hope this helps!