Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Honored Contributor

Bar Chart Colours

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)

6 Replies

Bar Chart Colours

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

chauhans85
Esteemed Contributor

Bar Chart Colours

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

stigchel
Honored Contributor

Bar Chart Colours

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)

chauhans85
Esteemed Contributor

Bar Chart Colours

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

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

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

Community Browser