topic Re: Counting Null in App Development https://community.qlik.com/t5/App-Development/Counting-Null/m-p/1197996#M22613 <HTML><HEAD></HEAD><BODY><P>Count({$&lt;QTD_VDA_UND<SPAN style="font-size: 13.3333px;">-={""}</SPAN>&gt;}distinct DTA_AGENDA)</P></BODY></HTML> Mon, 17 Oct 2016 10:52:24 GMT 2016-10-17T10:52:24Z Counting Null https://community.qlik.com/t5/App-Development/Counting-Null/m-p/1197995#M22612 <HTML><HEAD></HEAD><BODY><P>Hello everyone, </P><P><BR />The task looks easy but I am stuck on this, so anyone know how to count null like in the image</P><P></P><P><IMG alt="123.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/140648_123.PNG" style="height: 292px; width: 620px;" /></P><P>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)</P><P></P><P>Just explaining a bit more<BR />I have an master calendar (day,month,year...) creating every day from the min(date) to max(date)</P><P></P><P>This formula gets all the day that are not null but I wanna just the opposite</P><P></P><P>Count({$&lt;QTD_VDA_UND-={"=Null()"}&gt;}distinct DTA_AGENDA)</P><P></P><P>someone to help??</P></BODY></HTML> Wed, 22 Dec 2021 15:42:54 GMT https://community.qlik.com/t5/App-Development/Counting-Null/m-p/1197995#M22612 caiogil1 2021-12-22T15:42:54Z Re: Counting Null https://community.qlik.com/t5/App-Development/Counting-Null/m-p/1197996#M22613 <HTML><HEAD></HEAD><BODY><P>Count({$&lt;QTD_VDA_UND<SPAN style="font-size: 13.3333px;">-={""}</SPAN>&gt;}distinct DTA_AGENDA)</P></BODY></HTML> Mon, 17 Oct 2016 10:52:24 GMT https://community.qlik.com/t5/App-Development/Counting-Null/m-p/1197996#M22613 2016-10-17T10:52:24Z