Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

Is it null or is it missing?

NULL handling in QlikView

Specialist II
Specialist II

I'll read this material to answer you

Specialist II
Specialist II

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

So, its possible to solve this?

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

Generating Missing Data In QlikView

Specialist II
Specialist II

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