Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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.

1 Solution

Accepted Solutions
Highlighted

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

Best,

Sunny

View solution in original post

4 Replies
Highlighted
Not applicable

Mapping Load

NULL(),

'<UNKNOWN>'

AUTOGENERATE 1;

Highlighted

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

Best,

Sunny

View solution in original post

Highlighted
Not applicable

MAP country_Name using map_nulls;

Highlighted

try like this

=NullCount(Country_Name)