Using Colormix1 for rows in Pivot Table

[gsanthoshkumar]

Hi guys,

The below expression colors by each column

ColorMix1(rank(total column(1))/noofrows(TOTAL), Green(), Red())

What will be expression, if I want to colormix across rows?

Thanks

Sam

[Brett_Bleess]

Here is a Design Blog post that may be of some help, but not exactly sure of what you are really trying to accomplish, so a screenshot of what you want may be helpful for others to offer further advice on how to go about things on this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Colors-in-charts/ba-p/1475280

Regards,
Brett

[gsanthoshkumar]

Thank you Brett. 

I have data from 0.01% to 60% and I would like to use color gradient for the entire pivot table (attached). If I use colormix1 function, the colors are almost same as in the attachment.

Color Expression:

colormix1(Sum({$<site= , line =,  name ={'used'}>} value)
/ Sum({$<site= , line =,  name ={'manu'}>} value)  , green(), red())