This content has been marked as final. Show 3 replies
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