Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple colors problem

Dear community,

I have an expression for background color:

color(fieldindex('BrandName',BrandName))

When there is more than 200 BrandName, the color will go wrong, such as same green color for 3 different brands, anyone could help?

do I need to set it to multicolored or persistent color?

Thanks and best regards,

Chanel

3 Replies
fkeuroglian
Partner - Master
Partner - Master

Try this

Good luck

Anonymous
Not applicable
Author

Hi Chanel,

The Color function will return the relevant RGB value based on the current palette - so you're actually limited to 20, then they will start to repeat. So Color(21) will be the same as Color(1). When you have a large number of brands that you need to distinguish between you're better setting distinct values in the script and using ApplyMap to set the value - http://community.qlik.com/blogs/qlikviewdesignblog/2012/12/04/colors-in-charts

With over 200 brands is it necessary to specify different colors - colors in charts should always have a meaning so consider what the purpose of the colors are in your chart.

mahesh_agrawal
Creator
Creator

Use Color Mix wizard