3 Replies Latest reply: Dec 22, 2017 8:22 AM by Mohammed Al Radi RSS

    Removing a blank Blank Value Count Function

    Mohammed Al Radi

      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