
Contributor II
2022-12-01
10:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ColorMix1 wrong color
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)).
558 Views
1 Solution
Accepted Solutions


MVP
2022-12-01
12:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=ColorMix1(AGGR(Min(ID),ID_GR,ID_ODD)/100.0,red(),green())
537 Views
2 Replies


MVP
2022-12-01
12:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=ColorMix1(AGGR(Min(ID),ID_GR,ID_ODD)/100.0,red(),green())
538 Views

Contributor II
2022-12-02
03:30 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Fantastiko!
Thanks!
