topic exclude nulls on table chart in App Development

exclude nulls on table chart

joeybird — Tue, 21 Feb 2017 10:16:55 GMT

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

sunny_talwar — Tue, 21 Feb 2017 10:20:58 GMT

May be try this:

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

joeybird — Tue, 21 Feb 2017 10:29:43 GMT

this brings back all CustomerID, giving a 1 to all the null records for Department_Catering and 0 to the others

how do I limit the records shown in the table to just the ones with the 1 count please?

please help

sunny_talwar — Tue, 21 Feb 2017 10:32:17 GMT

Uncheck 'Show Zero Values under Add-Ons -> Data handling