topic Re: How to display the null values for a column in QlikView

How to display the null values for a column

Mon, 01 Feb 2016 12:15:00 GMT

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 — Mon, 01 Feb 2016 12:22:09 GMT

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

NullCount([Date Received])

Kushal_Chawda — Mon, 01 Feb 2016 12:27:59 GMT

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

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

Mon, 01 Feb 2016 12:28:01 GMT

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 — Mon, 01 Feb 2016 12:34:53 GMT

Alternative would be to do this:

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

HirisH_V7 — Mon, 01 Feb 2016 12:47:04 GMT

Hi ,

Check this,

-Hirish

Wed, 03 Feb 2016 08:32:52 GMT

Thanks All for your valued solutions.