Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
malradi88
Creator II
Creator II

Removing a blank Blank Value Count Function

Dear Qlik Community,

I hope this finds you well. I have the following formula that works fine for counting the specified subfield (# of schools)

Count (Distinct (subfield (key,'+', 2)))


However there is one blank value that is being counted in this KPI  (I confimed in the excel sheet that one cell does not have a school name) so instead of 48 schools it is counting 49. How can I get rid of this blank value?


Thank you in advance for your support


Best,


Mohammed

1 Solution

Accepted Solutions
sunny_talwar

Or this

Count(DISTINCT If(Len(Trim(SubField(key, '+', 2))) > 0, key))

View solution in original post

3 Replies
pradosh_thakur
Master II
Master II

Count (Distinct (subfield (if(len(trim(key))>0,key),'+', 2)))



Learning never stops.
sunny_talwar

Or this

Count(DISTINCT If(Len(Trim(SubField(key, '+', 2))) > 0, key))

malradi88
Creator II
Creator II
Author

Thank you all for your help Much appreciated