Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
caiogil1
Contributor III
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??

I hope to learn a lot here and help if I can
Labels (1)
1 Reply
Not applicable

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