Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator 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
sunny_talwar

May be this

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