I don't know whether I understood correctly, please check the attached image if you are expecting the same download QVW file from the below URL
Refer Products tab and Margin (Heat chart)
Hope this helps you.
if you have a field with values between 0 and 1 (0 to 100 %), e.g. called Dye%, your background color attribute (e.g. in expression tab, open the attributes by clicking on the + sign next to the expression) could look like this:
=RGB(255* Dye% ,255-255* Dye%,0)
This looks like to be equivalent to using the colormix1 function:
If you want to get blue in the middle of the range, it could look like
or (this looks different, more pure blue):
See also attached,
GreenToRedDye.qvw 160.0 K
thanks for your explanation. it was very helpful,
the "rgb" formula works fine in the range from 0 to 1 !
but how should a formula be defined , that
a) works in a range form " 0 to 100 "
b) is it although possible to dye dimensions, that are containing e.g. total amount of turnover?