ColorMix1 wrong color

[Carlo_Romagnano]

ColorMix1 sometime returns the wrong color when used in "Background color" of a Dimension and if there are some dimensions that have multiple row (I suppose).

See the attached sample "123.qvw". There are two chart: that on left is the wrong result and the other on the right is the "GOOD" one. As you can see, the expression of ColorMix1 in the dimension returns the right value (e.g. ARGB(255,115,13,0)).

[MarcoWedel · Accepted solution]

=ColorMix1(AGGR(Min(ID),ID_GR,ID_ODD)/100.0,red(),green())

[Carlo_Romagnano]

Fantastiko!

Thanks!