Re: Conditional Formatting using Colormix1 function
If I understood correctly, you are wondering why your figure in column NPP Contacted for row Tecfidera is having a white background?
I think that the problem is that your max(<EXP>) (divisor) is for mentioned above equal to 0. In that case, whatever your <EXP> will be, the result will be always evaluated like an error as you cannot divide by 0 and therefore Qlik Sense will apply default colour - White.
The case where you see 0 and you have a colour like a background is when your <EXP> (dividend) is equal to 0. The whole expression will be evaluated like a 0 as this is a valid expression…0/300 is 0.