how to show null value in KPI field

[#1]

Hi guys! I hope that you can help me with this.

I'm new usign Qlik Sense Desktop and i'm making some visualizations. One, in specific, i need to show some fields that at my ODBC connect that are empty.

I tried to use some formulas, and i'm a newer user in it too, and it showed wrong values.

when i use the  Count(if(isnull([queue]),1,0)) formula it shows me wrong values that dont matches with my mysql data. When I use the

isnull(trim([sla])) formula it shows me the -1 number.

What I'm doing wrong?

Thanks in advance.

[maxgro]

if you have true null the if(isnull(field), ...., ......) should works

if you have blank, space, use if(len(trim(field))=, ....., .....)

you can also have missing, here a detailed explanation

NULL handling in QlikView

[robert_mika]

Could you post your qvf file or screen shots from both data sets,

Is possible that some of your calculations returns missing values:

Missing values in PivotTable

[paul_scotchford · Accepted solution]

try ...

Count(if(isnull([queue])=-1,1,0))

True from an IsNull() test is -1 , you just left that out in the expression. I'm not sure if Qlik supports an implicit 'True' which your expression appears to suggest. I always code explicit for null testing anyway by habit.

[#5]

Thank you all guys!