Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator II

count of blank records

Hi Everyone,

I have one field called country. In country I have some blank records. Please help me on how to calculate the Blank records in that field.

I have attached the sample data excel file here.

In the excel out of 16 rows I have 7 blank records. How to get the count of blank records.

country.png

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

try this

=NullCount(Field)

View solution in original post

6 Replies
sergio0592
Specialist III
Specialist III

Try with :

=count({ $<Country={''} > }  Country)

pradosh_thakur
Master II
Master II

try this

sum(isnull(Country)=-1,1,0)

else

sum(if(len(Country)=0,1,0)

regards

Pradosh

Learning never stops.
Chanty4u
MVP
MVP

try this

=NullCount(Field)

View solution in original post

its_anandrjs

Can you check this script as well as in the load script.

In script load do this way

LOAD *,if(IsNull(Country)=-1 or len(Country)=0,'Null',Country) as CountryChk;

LOAD * Inline[

Country,Id

a,10

b,20

c,30

,40

d,50

e,60

,50

f,80  ];

And on UI count it in any text or chart

=Count( {<CountryChk={'Null'}>} Country)

vishsaggi
Champion III
Champion III

Try this?

LOAD RowNo() AS Rows, IF(Len(Trim(Country)) = 0, Null(), Country) AS Country

FROM

[..\Desktop\Sample data - Country.xlsx]

(ooxml, embedded labels, table is Sheet1);

Use like

= Sum(IF(ISNULL(Country) = -1, 1, 0))

its_anandrjs

On the result to you have any confusion or you looking something else on this let me know.

With Flag field

=Count( {<CountryChk={'Null'}>} Country)

With SET Analysis

=count({ $<Country={"=Len(Country)=0"} > }  Country)

OP3.PNG