is there any function for missing values?

[#1]

hello,

I am working on a table chart. I have some cells missing values or appearing as null. I want to highlight the null values,missing values and 0 values as different colors.

How can i identify the null and missing values? i think we have isnull function for null values but what function is used for missing values?

Arif

[#2]

hello

Im new in QV but maybe it can help you. maybe not >.<

In expression background type like this

if(fieldname='0' or len(fieldname)=0, red())

Sorry if its net help you.

[#3]

hello,

Thanks for your reply. If I have to seperate 0 values and missing values seperately, then how do i do it?

also, the red() function insert a text rgb(128,0,0) but it does not actually color the cell background red. How do i conditionally set the background to red if the value is missing?

Arif

[nathanfurby]

NULL and Missing should be the same right?

If you put this kind of statement in the Expression/Dimension 'Text Color' box it should work:

=If(IsNull(Field),Red())

[#5]

Can you please insert sample data or something

[#6]

Hello,

I am using the following expression

=if(sum(no_of_rows)=0,red(),sum(no_of_rows))

The sample data that is displayted is below. As you can see, the above expression cause the table to display the rgb(128,0,0) rather than actually coloring the cell red. Can you please tell me what mistake am i making here

Arif

[nathanfurby]

You need to put your expression for colour in the Background color section in the chart designer. See pic:

[nathanfurby]

The expression should be:

=if(sum(no_of_rows)=0,Red())

[#9]

Yep. Nathan's right. You should use this expression in background color. But i said it before. It seams you didn't get it right?

[nathanfurby]

So you did