How to display the null values for a column

[#1]

Dear QVExperts,

I have a table with column, [Date Received] with total 117 rows

Out of which, two rows are null.

How to display the Count([Date Received])

without null as 115 rows

with null as 2 rows.

Thanks

[sunny_talwar]

You can do a count of Null using NullCount() function:

NullCount([Date Received])

[Kushal_Chawda]

without Null= count(if(len(trim([Date Recieved]))>0,[Date Recieved]))

Null = count(if(len(trim([Date Recieved]))=0,[Date Recieved]))

[#4 · Accepted solution]

Hi Sasi,

Below code will be help ful to you.

check:

LOAD sum(if(isnull(Customer)=0,1,0)) as  notnullvalue,

         sum(if(isnull(Customer)=0,0,1)) as  nullvalue

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

thanks,

Sreeman

[sunny_talwar]

Alternative would be to do this:

RangeSum(Count([Date Received]) + NullCount([Date Received]))

[HirisH_V7]

Hi ,

Check this,

Finding NULL

-Hirish

[#7]

Thanks All for your valued solutions.