topic Bar Chart Colours in QlikView

Bar Chart Colours

Tue, 23 Aug 2011 13:27:15 GMT

Hi All,

I have a Bar Chart for 24 months history of stocks. I’vetried to change the colors but in the Chart Properties – Color tab you can onlycontrol 18 of them, is there any way to put that color choice somewhere in theExpression formula?

Thanks in advance..

cheers,

mem

Bar Chart Colours

its_anandrjs — Tue, 23 Aug 2011 13:52:45 GMT

Hi,

Yes you are able to set the many colors but you need to set either it in the load statement of the load script and set it from there to change the colors.

Reagrds,

Anand

Bar Chart Colours

SunilChauhan — Tue, 23 Aug 2011 15:16:07 GMT

go to chart properties

-> colors->repeat last 4 color

from here u can control last colors

i.e more than 18 th color wil be same

Bar Chart Colours

stigchel — Tue, 23 Aug 2011 15:42:43 GMT

Yes you can, expand the expression by clicking on the plus sign in front of it. Now you will see several options for this expressiion for which you can use another expression including background color. Use the RGB() function to set a color.

You may want to load the colors for each month in a table (linked to your dimension), in which case you must load the R,G and B values seperately. For example fields R,G and B the expression would become =RGB(R,G,B)

Bar Chart Colours

SunilChauhan — Tue, 23 Aug 2011 15:45:32 GMT

after 18 colors again same colors are repeating

that means

1st and 19 th color will be same

2nd and 20th color will be same

3rd and 21th color will be same

and so on

Bar Chart Colours

its_anandrjs — Tue, 23 Aug 2011 15:46:15 GMT

Hi,

You need to define the 24 colors in the load statement and use that colors in the chart and use the code RGB(value,value,value) and use it as a colors.

Regards,

Anand

Bar Chart Colours

its_anandrjs — Tue, 23 Aug 2011 15:52:35 GMT

Hi,

You need to load inline values for the RGB(value,value,value) and apply all this to your categories. Then use all ths RGB values as color value.

Regards,

Anand