topic how to show null value in KPI field in App Development

how to show null value in KPI field

Thu, 26 Nov 2015 19:35:54 GMT

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.

Re: how to show null value in KPI field

maxgro — Thu, 26 Nov 2015 22:13:03 GMT

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

Re: how to show null value in KPI field

robert_mika — Thu, 26 Nov 2015 22:31:08 GMT

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

Re: how to show null value in KPI field

paul_scotchford — Fri, 27 Nov 2015 04:11:03 GMT

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.

Re: how to show null value in KPI field

Fri, 27 Nov 2015 11:58:54 GMT

Thank you all guys!