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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Case 932 How to make the count result = 3 ?

Hi All

I have below table , it display 4 is wrong  , how to make it display 3 ? Enclosed ny QVW for your ref.

paulyeo11_0-1599823399011.png

 

1 Solution

Accepted Solutions
Kushal_Chawda

@paulyeo11  try below expression

count(distinct {<[E-Mail List]={"=len(trim([E-Mail List]))>0"}>}[E-Mail List])

View solution in original post

3 Replies
tresesco
MVP
MVP

Change the expression to:

count(distinct {<[E-Mail List]={"=Len(Trim([E-Mail List]))>0"}>} [E-Mail List])

Kushal_Chawda

@paulyeo11  try below expression

count(distinct {<[E-Mail List]={"=len(trim([E-Mail List]))>0"}>}[E-Mail List])

paulyeo11
Master
Master
Author

Thank you very much.