Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Good luck
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.
Use Color Mix wizard