Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

soniasweety
Valued Contributor III

Null count

Hi All,

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

is there any specific method ?

Thanks

Sony

Tags (1)
11 Replies
suhaskharat
New Contributor III

Re: Null count

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

Partner
Partner

Re: Null count

Hi Sony,

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

arvind1494
Valued Contributor

Re: Null count

Use :

NullCount(field name)

soniasweety
Valued Contributor III

Re: Null count

its not working tried  nucount.PNG

Partner
Partner

Re: Null count

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>))

trdandamudi
Honored Contributor

Re: Null count

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

Len(Trim(Field1))=0

suhaskharat
New Contributor III

Re: Null count

Use Both

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

So that it will count null and spaces both.

Highlighted
sibin_jacob
Contributor III

Re: Null count

Try set analysis with -=

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


soniasweety
Valued Contributor III

Re: Null count

thanks all its working this

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