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

[schefflera]

Hi Tom,

try this:

Delete the comma at the End. It says, if the condition are not true, use nothing. That is why your other Names are white.

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

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

))

If you like not only one color for the other valure. Set in the color tab in the chart setting the checkbox "multicolor".

Works fine for me.