Is it possible to do Multicolor on a Combo Chart?

[#1]

Hi,

I have a Combo Chart (a line and bars). I would like the bars to be "multicolored". But when I go to chart Properties | Colors, the "Multicolored" box is greyed out.

Is there a way to do it?

Thanks,

Joseph

[johnw]

When you have more than one expression, QlikView is using the colors to distinguish between the expressions, not between your dimension values. One way to force your colors in is on the expressions tab, click on the + next to the expression, click on Background Color, and enter an expression to assign colors to your dimension values. See attached example. The color expression isn't limited to colors like blue() that I used in the example. You can use things like rgb(180,120,10).

OK, don't see attached. The forum still isn't letting me upload. Anyway, I have a dimension of "Person" and an expression sum(Sales). For the background color, I use this expression:

pick(match("Person",'Andy','Bill','Carla','Dana','Eirik','Fred'),red(),blue(),green(),lightred(),lightblue(),lightgreen())

[#3]

Is it possible to force the colors to the legend at the same time?

For a bar chart, different colors appear on the bar and legend automatically. But when it becomes a combo chart, the colors disappear from both the bar and legend.

While it is possible to force the bar colors via the background color expression, the legend does not automatically display the new colors specified in the expression.

[johnw]

Do you mean the legend that displays to the right of the chart? Properties -> Presentation -> Show Legend? If you only have a single dimension and single expression, there is no legend. If you add an expression, the legend appears, but is used to distinguish between your two expressions. If you instead add a dimension, the legend is used to distinguish between your second dimension values. I guess I'm unclear what case you're looking at where bar charts and combo charts work differently.