Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
eduardo_dimperi
Not applicable

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
Not applicable

Re: Working with null results

Is it null or is it missing?

NULL handling in QlikView

eduardo_dimperi
Not applicable

Re: Working with null results

I'll read this material to answer you

eduardo_dimperi
Not applicable

Re: Working with null results

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

So, its possible to solve this?

sunny_talwar
Not applicable

Re: Working with null results

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

Generating Missing Data In QlikView

eduardo_dimperi
Not applicable

Re: Working with null results

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