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

    exclude nulls on table chart

    Joanna Seldon



      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