Removing a blank Blank Value Count Function

[malradi88]

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

[pradosh_thakur]

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

[sunny_talwar · Accepted solution]

Or this

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

[malradi88]

Thank you all for your help Much appreciated