Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar Chart Colours

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

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

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)

View solution in original post

6 Replies
its_anandrjs

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

SunilChauhan
Champion
Champion

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

Sunil Chauhan
stigchel
Partner - Master
Partner - Master

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)

SunilChauhan
Champion
Champion

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

Sunil Chauhan
its_anandrjs

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

its_anandrjs

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