Different color for each bar in bar chart

[#1]

Hi QV,

I have a requirement to assign different color for each bar in bar chart.

Here my Dimension is SEGMENT.

for this I have more than 250 records.

Its difficult for me to give background color with a conditional expression cause I have too many records.

So is there any direct way to do this in simple.

Thanks,

Ananth

[aveeeeeee7en]

Hi

See this:

http://community.qlik.com/docs/DOC-5189

You can also use ColorMix() Function by giving color ranges. It will select colors inbetween your given ranges.

Or do 1 thing. Go to Colors Tab, Define different Colors for each Box you have the option to give 18 different colors and then check Persistent colors.

After every 18 colors, the bars again start with the same colors 1-18 than again after 36 Bars same color pattern repition.

Hope that helps.

Regards

Aviral Nag

[#3]

Thanks for your response Nag.

[stigchel]

You could also make a table and load it with the fields SEGMENT, segR,segG,segB, these should be the respective rgb values you want to assign to each segment. Then in the expression tab of the properties expand the options for that expression by clicking the + sign and in the background color put the expresssion rgb(segR,segG,segB)