topic Re: Null count in QlikView

Null count

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i want to check in each filed null count how can i check this?

is there any specific method ?

Thanks

Sony

Re: Null count

suhaskharat — Thu, 09 Aug 2018 12:16:27 GMT

which kind of file are you referring. Please provide sample.

Re: Null count

ggijben — Thu, 09 Aug 2018 12:16:56 GMT

Hi Sony,

You can use =NullCount( <FieldName> ) to count null values for a specific field.

Re: Null count

arvind1494 — Thu, 09 Aug 2018 12:31:07 GMT

Use :

NullCount(field name)

Re: Null count

soniasweety — Thu, 09 Aug 2018 12:39:02 GMT

its not working tried

Re: Null count

ggijben — Thu, 09 Aug 2018 12:43:28 GMT

Are you sure that there are real NULL values instead of " "? An empty value is still a value, which is different from NULL.

Can you try this:

Count(If(Len(Trim(<FIELD>))=0,<FIELD>))

Re: Null count

trdandamudi — Thu, 09 Aug 2018 12:44:40 GMT

Show us some sample data please. Also you can try below:

Len(Trim(Field1))=0

Re: Null count

suhaskharat — Thu, 09 Aug 2018 12:47:26 GMT

Use Both

=NullCount(Tot) + Count(If(Len(Trim(Tot))=0,Tot))

So that it will count null and spaces both.

Re: Null count

sibin_jacob — Thu, 09 Aug 2018 12:48:23 GMT

Try set analysis with -=

Count({<Column_Name-={"*"}>} Column_Name)

Re: Null count

soniasweety — Thu, 09 Aug 2018 12:49:02 GMT

thanks all its working this

=Count(distinct If(Len(Trim(Type))=0,Type))

Re: Null count

Ponkaviyarasu — Thu, 09 Aug 2018 12:49:56 GMT

Hi Sony,

Try

MissingCount(FieldName)

Thanks,

Kavi

Re: Null count

andrei_delta — Thu, 09 Aug 2018 13:05:25 GMT

hi,

count( {<[Field]={''}>} [Field])

Hope it helps,

Andrew