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.
caiogil1
New Contributor III

Counting Null

Hello everyone,


The task looks easy but I am stuck on this, so anyone know how to count null like in the image

123.PNG

I wanna count all the null cells in that table on the right, this means every day that there is no sale(measure field = qty_sold)

Just explaining a bit more
I have an master calendar (day,month,year...) creating every day from the min(date) to max(date)

This formula gets all the day that are not null but I wanna just the opposite

Count({$<QTD_VDA_UND-={"=Null()"}>}distinct DTA_AGENDA)

someone to help??

1 Reply
Not applicable

Re: Counting Null

Count({$<QTD_VDA_UND-={""}>}distinct DTA_AGENDA)