topic Re: reg null values count at report level in QlikView https://community.qlik.com/t5/QlikView/reg-null-values-count-at-report-level/m-p/671886#M244067 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check this</P><P></P><P><A href="https://community.qlik.com/docs/DOC-3155">NULL handling in QlikView</A></P><P></P><P></P><P>regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 23 Sep 2014 11:58:11 GMT ashfaq_haseeb 2014-09-23T11:58:11Z reg null values count at report level https://community.qlik.com/t5/QlikView/reg-null-values-count-at-report-level/m-p/671885#M244066 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have another req... as i have null values at DB level...i would like to get the null records count at report level..</P><P>anybody has done earlier on this?</P></BODY></HTML> Tue, 23 Sep 2014 11:55:52 GMT https://community.qlik.com/t5/QlikView/reg-null-values-count-at-report-level/m-p/671885#M244066 2014-09-23T11:55:52Z Re: reg null values count at report level https://community.qlik.com/t5/QlikView/reg-null-values-count-at-report-level/m-p/671886#M244067 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check this</P><P></P><P><A href="https://community.qlik.com/docs/DOC-3155">NULL handling in QlikView</A></P><P></P><P></P><P>regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 23 Sep 2014 11:58:11 GMT https://community.qlik.com/t5/QlikView/reg-null-values-count-at-report-level/m-p/671886#M244067 ashfaq_haseeb 2014-09-23T11:58:11Z Re: reg null values count at report level https://community.qlik.com/t5/QlikView/reg-null-values-count-at-report-level/m-p/671887#M244068 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you can use the NullCount function, or another option is to transform your nulls in the script to real data 'Null' for example so they are selectable and easier to investigate</P><P>eg if(isnull([Field 1]),'Null',[Field 1]) As [Field 1]</P><P></P><P>hope that helps</P><P>Joe</P></BODY></HTML> Tue, 23 Sep 2014 11:58:59 GMT https://community.qlik.com/t5/QlikView/reg-null-values-count-at-report-level/m-p/671887#M244068 2014-09-23T11:58:59Z Re: reg null values count at report level https://community.qlik.com/t5/QlikView/reg-null-values-count-at-report-level/m-p/671888#M244069 <HTML><HEAD></HEAD><BODY><P>Have a look at NullCount() as well.</P></BODY></HTML> Tue, 23 Sep 2014 12:00:24 GMT https://community.qlik.com/t5/QlikView/reg-null-values-count-at-report-level/m-p/671888#M244069 tresB 2014-09-23T12:00:24Z