3 Replies Latest reply: Feb 21, 2017 5:32 AM by Sunny Talwar RSS

    exclude nulls on table chart

    Joanna Seldon


      hi

       

      I have tried these following ways to show in a table chart on a qlik sense sheet only the CustomerIDs that have null for Department_Catering

       


      Count({<Department_Catering= {"=Len(Trim(Department_Catering)) > 0"}>}CustomerID)

       

      this above gives the answer to all that has a Department_Catering, but I want the ones that do not

       

      if I do this

       

      Count({<Department_Catering -= {"=Len(Trim(Department_Catering)) > 0"}>}CustomerID)

       

      I get no records

       

      please help