Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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