Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist 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

11 Replies
Highlighted
Contributor III
Contributor III

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

Highlighted
Partner
Partner

Hi Sony,

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

Highlighted
Specialist
Specialist

Use :

NullCount(field name)

Highlighted
Specialist III
Specialist III

its not working tried  nucount.PNG

Highlighted
Partner
Partner

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

Highlighted
Master II
Master II

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

Len(Trim(Field1))=0

Highlighted
Contributor III
Contributor III

Use Both

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

So that it will count null and spaces both.

Highlighted
Creator III
Creator III

Try set analysis with -=

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


Highlighted
Specialist III
Specialist III

thanks all its working this

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