Qlikview - how to assign background colors in chart?

[tomdabek]

I am using the background color property to assign colors to known values, but there are dozens of possibilities and i only want to fix the color for a few of them.  The result is that all other values just show up as white.

Background Color property:

if([Name]='Tom',green(),

if([Name]='Bob',blue(),

))

All the other values for Name just show up as white, i just want the default or random colors to be used.

Any ideas?

Thanks

[sergio0592]

Hi, try with:

pick(match(Name,'Tom','Bob')+1, white(), green(), blue())

Is it what you're trying to achieve?

[tomdabek · Accepted solution]

This works

if([Name]<>'Tom',RGB(255 * rand(), 255 * rand(), 255 * rand())

[tomdabek]

No, it left other values gray