Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Colormix in straight table how to deviate color for one specific value?

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: ColorMix2 (if(rangemin(vAantalBedden,rangemax(count(%StayDay),1))<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))

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?

0 Replies