topic Re: count null and non null values problem in QlikView https://community.qlik.com/t5/QlikView/count-null-and-non-null-values-problem/m-p/966139#M331162 <HTML><HEAD></HEAD><BODY><P>Post a sample plz</P></BODY></HTML> Tue, 13 Oct 2015 09:31:31 GMT sujeetsingh 2015-10-13T09:31:31Z count null and non null values problem https://community.qlik.com/t5/QlikView/count-null-and-non-null-values-problem/m-p/966138#M331161 <HTML><HEAD></HEAD><BODY><P>Hi im trying to count all "LanID" where they have 2 or less then 2 " DocName"&nbsp; and the null values for those that dont have any "DocName"</P><P></P><P>=count(DISTINCT {&lt;LanID = {"=count(distinct DocName)&lt;=2"}&gt;}LanID)</P><P>+&nbsp; count(DISTINCT LanID) -count(DISTINCT {&lt;DocName = {"*"}&gt;}LanID)&nbsp; </P><P></P><P>This is my expression</P><P></P><P>The problem is when im trying to implement a YTD , MTYD and LYTD to this, it gets tricky,</P><P>For example :</P><P></P><P>All LanIDs that have &lt;=2 DocNames including 0 and null value is = 198 LanIDs</P><P></P><P>When i press the current Year = 136 LanIDs</P><P></P><P>When i press current Year and choose Oct and Sep = 146 ,</P><P></P><P></P><P>How&nbsp; could this be ? </P><P></P><P>I have tried with NullCount and adding the LanIDs manually, but wont work..</P><P></P><P>Any Help would be much appriciated .</P></BODY></HTML> Tue, 13 Oct 2015 09:19:48 GMT https://community.qlik.com/t5/QlikView/count-null-and-non-null-values-problem/m-p/966138#M331161 2015-10-13T09:19:48Z Re: count null and non null values problem https://community.qlik.com/t5/QlikView/count-null-and-non-null-values-problem/m-p/966139#M331162 <HTML><HEAD></HEAD><BODY><P>Post a sample plz</P></BODY></HTML> Tue, 13 Oct 2015 09:31:31 GMT https://community.qlik.com/t5/QlikView/count-null-and-non-null-values-problem/m-p/966139#M331162 sujeetsingh 2015-10-13T09:31:31Z