Easy way of coloring items in bubble chart based on a different dimension

[#1]

Current chart

I've created a bubble chart representing ~150 projects. QlikView automatically assigns a color to each of the projects.

What I'd like to do

Each of these projects belongs to one and only one business unit, and there are 10 business units in total. I'd like to color the projects by business unit. I could build a separate table defining RGB values for each of these business units, but I wanted to know if there's an easier way to force QlikView to assign colors based on a dimension other than the one I've specified in the Dimensions tab of the Chart Properties dialog box.

Thanks for the feedback!

[#2 · Accepted solution]

Just add a 2nd dimension BU !

So you must have 2 dimensions : Project & BU

regards

[#3]

Jean-Jacques, thanks, that seems to do the trick. By default, adding another dimension triggers two changes that you need to undo:

1. Adding another dimension causes lines connecting the bubbles to appear. These lines can be removed by selecting 'Only Symbols' in the Representation drop-down menu on the Presentation tab of the Chart Properties dialog.
2. Adding another dimension also shows a legend for all of the expressions, which in this case isn't needed (indeed, it makes no sense). The legend can be hidden by unchecking the 'Show Legend' box, which is also on the Presentation tab of the Chart Properties dialog.