Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

suvechha_b
Contributor III

Count distinct Policy Number if particular field is null ?

Hi All ,

How to count distinct Policy Number if 'POLICY_HOLDER_EMAIL_ADDRESS' field is null.

Sample model attached.

 

1 Reply

Re: Count distinct Policy Number if particular field is null ?

May be this

Count(DISTINCT {<[Policy Number] = {"=Len(Trim(POLICY_HOLDER_EMAIL_ADDRESS)) = 0"}>} [Policy Number])