topic is there any function for missing values? in QlikView

is there any function for missing values?

Thu, 07 Apr 2011 08:19:40 GMT

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

is there any function for missing values?

Thu, 07 Apr 2011 08:29:50 GMT

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.

is there any function for missing values?

Thu, 07 Apr 2011 08:43:07 GMT

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

is there any function for missing values?

nathanfurby — Thu, 07 Apr 2011 08:50:59 GMT

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())

is there any function for missing values?

Thu, 07 Apr 2011 08:51:51 GMT

Can you please insert sample data or something

is there any function for missing values?

Thu, 07 Apr 2011 11:03:15 GMT

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

is there any function for missing values?

nathanfurby — Thu, 07 Apr 2011 11:09:35 GMT

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

is there any function for missing values?

nathanfurby — Thu, 07 Apr 2011 11:12:21 GMT

The expression should be:

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

is there any function for missing values?

Thu, 07 Apr 2011 11:50:22 GMT

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?

is there any function for missing values?

nathanfurby — Thu, 07 Apr 2011 12:03:05 GMT

So you did

is there any function for missing values?

Thu, 07 Apr 2011 12:07:29 GMT

Sorry Nathan. I'm just telling >.O

is there any function for missing values?

nathanfurby — Thu, 07 Apr 2011 12:09:40 GMT

No I agree with you - I hadn't seen your post