Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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
suhaskharat
Contributor III
Contributor III

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

ggijben
Partner - Creator II
Partner - Creator II

Hi Sony,

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

arvind1494
Specialist
Specialist

Use :

NullCount(field name)

soniasweety
Master
Master
Author

its not working tried  nucount.PNG

ggijben
Partner - Creator II
Partner - Creator II

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
Master II
Master II

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

Len(Trim(Field1))=0

suhaskharat
Contributor III
Contributor III

Use Both

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

So that it will count null and spaces both.

sibin_jacob
Creator III
Creator III

Try set analysis with -=

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


soniasweety
Master
Master
Author

thanks all its working this

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