Discussion board where members can get started with Qlik Sense.
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.
If (Isnull(ENTRADA_DESENV), 'NAO CONSTA',ENTRADA_DESENV) - Not Work
If (Isnull(ENTRADA_DESENV),0,ENTRADA_DESENV) - Not Work
Any ideia why?
Is it null or is it missing?
NULL handling in QlikView
I'll read this material to answer you
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
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