topic Colormix in straight table how to deviate color for one specific value? in QlikView https://community.qlik.com/t5/QlikView/Colormix-in-straight-table-how-to-deviate-color-for-one-specific/m-p/91172#M509802 <HTML><HEAD></HEAD><BODY><P>I made a heatmap in QLikView by using a straight table and color each cell based on it's numeric value. The expression that I used is: <STRONG>ColorMix2 (if(rangemin(vAantalBedden,rangemax(count(%StayDay),1))&lt;vAantalBedden / 2,(rangemin(vAantalBedden,rangemax(count(%StayDay),1))-vAantalBedden / 2)/(vAantalBedden / 2-1),(rangemin(vAantalBedden,rangemax(count(%StayDay),1))-vAantalBedden / 2)/(vAantalBedden-vAantalBedden / 2)), ARGB(255, 255, 0, 0), ARGB(255, 0, 255, 0), ARGB(255, 255, 255, 0))</STRONG></P><P></P><P>vAantalBedden has the numeric value of 55. 55 has the color green and 0 the color red. Other values has a gradient between red en green (27 is yellow). I tried to give only the value of 0, a different color like gray without using the gradient colors. How to perform this?</P></BODY></HTML> Mon, 16 Jul 2018 14:32:34 GMT qlikmark1990 2018-07-16T14:32:34Z Colormix in straight table how to deviate color for one specific value? https://community.qlik.com/t5/QlikView/Colormix-in-straight-table-how-to-deviate-color-for-one-specific/m-p/91172#M509802 <HTML><HEAD></HEAD><BODY><P>I made a heatmap in QLikView by using a straight table and color each cell based on it's numeric value. The expression that I used is: <STRONG>ColorMix2 (if(rangemin(vAantalBedden,rangemax(count(%StayDay),1))&lt;vAantalBedden / 2,(rangemin(vAantalBedden,rangemax(count(%StayDay),1))-vAantalBedden / 2)/(vAantalBedden / 2-1),(rangemin(vAantalBedden,rangemax(count(%StayDay),1))-vAantalBedden / 2)/(vAantalBedden-vAantalBedden / 2)), ARGB(255, 255, 0, 0), ARGB(255, 0, 255, 0), ARGB(255, 255, 255, 0))</STRONG></P><P></P><P>vAantalBedden has the numeric value of 55. 55 has the color green and 0 the color red. Other values has a gradient between red en green (27 is yellow). I tried to give only the value of 0, a different color like gray without using the gradient colors. How to perform this?</P></BODY></HTML> Mon, 16 Jul 2018 14:32:34 GMT https://community.qlik.com/t5/QlikView/Colormix-in-straight-table-how-to-deviate-color-for-one-specific/m-p/91172#M509802 qlikmark1990 2018-07-16T14:32:34Z