Working with null results

[eduardo_dimperio]

Hey !

I was working in the grafic part and my table return some null values and its ok, but i want to chance null for zero  to numeric fields and 'Nao Consta' to string fields.

So I did this:

If (Isnull(CLIENTE), 'NAO CONSTA',CLIENTE)

And works to Cliente Field, but for my ENTRADA_DESENV, doesn't.

i.e

If (Isnull(ENTRADA_DESENV), 'NAO CONSTA',ENTRADA_DESENV) - Not Work

If (Isnull(ENTRADA_DESENV),0,ENTRADA_DESENV) - Not Work

Any ideia why?

Thank You.

[sunny_talwar]

Is it null or is it missing?

NULL handling in QlikView

[eduardo_dimperio]

I'll read this material to answer you

[eduardo_dimperio]

Its a missing value and now i'm more wise lol

So, its possible to solve this?

[sunny_talwar]

Never worked on it, so not 100% sure, but may be this:

Generating Missing Data In QlikView

[eduardo_dimperio]

Hey Sunny, this help but now that i know the difference between missing and null. I'll figure out something

Thank you for always helping me