Discussion board where members can get started with QlikView.
Please help me with the following question:
I have a table where the text color changes according to the value of the cell. However, when the value is null or zero, the formula does not work. How can I do?
This doesn't solve the problem you're asking about, but I'd do this:
DepartmentColors:LOAD * INLINE [singlaDepartamento,R,G,BENG,0,168,0CRT,255,0,0TRAF,255,0,255CAU,0,255,0MKTAS,128,0,0PA,255,255,0PED,0,255,255W,132,0,0];
And simplify your color expression to this:
But as I said, it won't solve the problem where the 0 and null rows don't pick up the color. What I just did an hour ago was to prevent myself from having null or 0. Something along these lines:
It worked for me, but there must be a better solution.
Thanks for the suggestion! But did not resolve the issue. The problem is related to the date filter. See the image below:
'CAU' and 'PA' does not appear colored as they are not contained in either category.