using where in qlik

[#1]

I have a field named inhabited, the possible values are null (displayed in qlik as - ) or a date.

I want to count how many fields are null and how many have a date filled in.

How do I do this in Qlik?

[tresesco · Accepted solution]

NullCount(inhabited)                                                // For Null count

Count(inhabited) - NullCount(inhabited)                 // For Date count

[#3]

len(date) >0

len(date)=0

[amit_saini]

Katleen,

You can try something like this:

First Method:

count(if(match(inhabited,'Null'),inhabited))--> For calculating Null values

count(if(match(inhabited,'Date'),inhabited))--> For Calculating Date values

Second Method: You can also count values by using where in script, see example below for calculating "Null" , similarly try for "Date"

load *

where
Inhabited = Null
;

Thanks,

AS

[aveeeeeee7en]

Hi Katleen

Create a Text Box and paste the below expressions:

For Nulls use:

=Count(Distinct if(Len(Trim(inhabited))=0,'Nulls'))

For Filled Dates use:

=Count(Distinct if(Len(Trim(inhabited))>0,'Dates'))

Hope that works for you.

Regards

Aviral Nag