Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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)