topic Re: how to color empty cells? in QlikView

how to color empty cells?

Thu, 03 Oct 2013 14:50:08 GMT

Good Day,

how do I color empty cells in a table dynamically?

Example: yellow coloring null fields.

I thank you!

Re: how to color empty cells?

Clever_Anjos — Thu, 03 Oct 2013 14:54:44 GMT

Expand your expression e look for Background Color

=if(IsNull(yourfield or expression),Yellow())

Re: how to color empty cells?

Thu, 03 Oct 2013 14:55:34 GMT

Hi,

In the expressions tab, double click on your expression

You will see several items, one of them is Background color : enter a definition (an expression) to color the cell

sth like ; if my expression is null then yellow

Fabrice

Re: how to color empty cells?

MayilVahanan — Thu, 03 Oct 2013 14:57:01 GMT

Try like this

Expression -> Background color

=If(IsNull(Expression) , Yellow(), Green())

// Here expression represents something like sum(sales)

Re: how to color empty cells?

Gysbert_Wassenaar — Thu, 03 Oct 2013 15:02:39 GMT

In a pivot table or straigth table chart you can do it like this:

Enable the grid and right click a cell and use Custom Format Cell to set the default background to yellow.

Next, open the charts properties window, go to the expressions tab and click on the + sign in front of the expression. Select background color and enter white() as expression.

That will give cells with a value a white background color while the other cells will have a yellow background. See attached example.