Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
joeybird
Contributor III

exclude nulls on table chart


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

3 Replies

Re: exclude nulls on table chart

May be try this:

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

joeybird
Contributor III

Re: exclude nulls on table chart

HI

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


Re: exclude nulls on table chart

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

Capture.PNG