Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Null Values

Hi Experts,

How to get null values count.

Ex:

My field name: Country_Name

Then I want null count for the Country_Name 

Thank you.

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

There is a qlikview's inbuilt function NullCount(), have you tried using that?

Best,

Sunny

View solution in original post

4 Replies
Not applicable

Mapping Load

NULL(),

'<UNKNOWN>'

AUTOGENERATE 1;

sunny_talwar
MVP
MVP

There is a qlikview's inbuilt function NullCount(), have you tried using that?

Best,

Sunny

Not applicable

MAP country_Name using map_nulls;

avinashelite
MVP
MVP

try like this

=NullCount(Country_Name)

Community Browser