topic Re: Multiple colors problem in QlikView

Multiple colors problem

Thu, 31 Jul 2014 00:57:30 GMT

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

Re: Multiple colors problem

fkeuroglian — Thu, 31 Jul 2014 02:16:13 GMT

Try this

Good luck

Re: Multiple colors problem

Anonymous — Thu, 31 Jul 2014 07:11:08 GMT

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.

Re: Multiple colors problem

mahesh_agrawal — Thu, 31 Jul 2014 10:00:48 GMT

Use Color Mix wizard