Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN 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])