topic Re: how this expression works??? in QlikView https://community.qlik.com/t5/QlikView/how-this-expression-works/m-p/657456#M240028 <HTML><HEAD></HEAD><BODY><P>hi</P><P>the function gives , it will aggregate the status based on the ID and then</P><P>gives the count noumber&nbsp; of NULL values</P><P></P><P></P><P>Go to Qlikview Help for more</P></BODY></HTML> Wed, 11 Jun 2014 10:49:44 GMT sasikanth 2014-06-11T10:49:44Z how this expression works??? https://community.qlik.com/t5/QlikView/how-this-expression-works/m-p/657455#M240027 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>can any one guide through the expression below ,i know something about this expression. for more details please guide me.</P><P>here you go</P><P>=nullcount(Total&lt;id&gt;status)</P><P></P><P>how it works .</P><P></P><P>Thank you.</P></BODY></HTML> Wed, 11 Jun 2014 10:43:44 GMT https://community.qlik.com/t5/QlikView/how-this-expression-works/m-p/657455#M240027 2014-06-11T10:43:44Z Re: how this expression works??? https://community.qlik.com/t5/QlikView/how-this-expression-works/m-p/657456#M240028 <HTML><HEAD></HEAD><BODY><P>hi</P><P>the function gives , it will aggregate the status based on the ID and then</P><P>gives the count noumber&nbsp; of NULL values</P><P></P><P></P><P>Go to Qlikview Help for more</P></BODY></HTML> Wed, 11 Jun 2014 10:49:44 GMT https://community.qlik.com/t5/QlikView/how-this-expression-works/m-p/657456#M240028 sasikanth 2014-06-11T10:49:44Z Re: how this expression works??? https://community.qlik.com/t5/QlikView/how-this-expression-works/m-p/657457#M240029 <HTML><HEAD></HEAD><BODY><P>In the chart where you use this, possibly there is multiple dimensions; <STRONG>id</STRONG> being one of them. The expression counts the null (null()) values for field <STRONG>status </STRONG>and gives the output <EM>as aggregated level of id dimension (</EM>Note: this aggregation is caused by 'Total &lt;id&gt;' in your expression<EM>)</EM>.</P></BODY></HTML> Wed, 11 Jun 2014 10:52:39 GMT https://community.qlik.com/t5/QlikView/how-this-expression-works/m-p/657457#M240029 tresB 2014-06-11T10:52:39Z Re: how this expression works??? https://community.qlik.com/t5/QlikView/how-this-expression-works/m-p/657458#M240030 <HTML><HEAD></HEAD><BODY><P>id&nbsp;&nbsp; status</P><P>1&nbsp;&nbsp;&nbsp; </P><P>2</P><P>3&nbsp;&nbsp;&nbsp; top</P><P>4&nbsp;&nbsp;&nbsp; bottom</P><P>5 </P><P>6</P><P>7&nbsp;&nbsp;&nbsp; top</P><P>8&nbsp; bottom</P><P></P><P>can you explain with this data.</P></BODY></HTML> Wed, 11 Jun 2014 13:48:04 GMT https://community.qlik.com/t5/QlikView/how-this-expression-works/m-p/657458#M240030 2014-06-11T13:48:04Z