Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
eduardo_dimperio
Specialist II
Specialist II

Working with null results

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.

Null_Value.JPG

5 Replies
sunny_talwar

Is it null or is it missing?

NULL handling in QlikView

eduardo_dimperio
Specialist II
Specialist II
Author

I'll read this material to answer you

eduardo_dimperio
Specialist II
Specialist II
Author

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
Specialist II
Specialist II
Author

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