Count Null Values specific to a field value

jlampard40 — Wed, 08 Aug 2018 10:22:19 GMT

Hi - I have a set of data which contains null data for a specific field, called 'Report Date'. I've managed to count the number of these Null Values as this is an important measure. However, I'd also like to count the number of times a specific field WITHIN this occurs.

So the formula below is what I've used to count the number of NULL Report Dates, based on the count of Staff Codes. This is working just fine:

=Count(DISTINCT{$<[Staff Code] = {"=NullCount([Report Date]) > 0"}>}[Staff Code)

What I need, is to then say, if that staff code is equal to code '7', what is the count now? So it's clearly just a development of the above set analysis code, but I'm not sure how to specify I want to provide another measure which is looking at Staff Code '7'...?

I really hope you can help as it's driving me a little loopy - I suspect it's very straight forward!! Thanks in advance.

Re: Count Null Values specific to a field value

vishsaggi — Wed, 08 Aug 2018 18:05:36 GMT

May be this?

=Count(DISTINCT{$<[Staff Code] = {"=NullCount({<[Staff Code] = {7} >} [Report Date]) > 0"}>}[Staff Code)

=Count(DISTINCT{$<[Staff Code] = {"=NullCount([Report Date]) > 0"}, [Staff Code] = {7} >}[Staff Code)

Re: Count Null Values specific to a field value

jlampard40 — Fri, 10 Aug 2018 06:48:54 GMT

Awesome help - thanks so much.

topic Re: Count Null Values specific to a field value in QlikView

Count Null Values specific to a field value

Re: Count Null Values specific to a field value

Re: Count Null Values specific to a field value