topic Using Colormix1 for rows in Pivot Table in App Development

Using Colormix1 for rows in Pivot Table

gsanthoshkumar — Wed, 28 Oct 2020 04:41:45 GMT

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

Re: Using Colormix1 for rows in Pivot Table

Brett_Bleess — Wed, 28 Oct 2020 11:47:29 GMT

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

Re: Using Colormix1 for rows in Pivot Table

gsanthoshkumar — Wed, 28 Oct 2020 14:56:00 GMT

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())