topic How to discard some fields to make count? in QlikView https://community.qlik.com/t5/QlikView/How-to-discard-some-fields-to-make-count/m-p/254206#M586057 <HTML><HEAD></HEAD><BODY><P>!Thanks for your great help¡</P></BODY></HTML> Fri, 05 Aug 2011 22:39:55 GMT 2011-08-05T22:39:55Z How to discard some fields to make count? https://community.qlik.com/t5/QlikView/How-to-discard-some-fields-to-make-count/m-p/254204#M586055 <HTML><HEAD></HEAD><BODY><P>Hi Everybody</P><P></P><P>I have a table like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="162" style="border: 1px solid #000000; width: 419px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID <BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID Padre<BR /></STRONG></SPAN></TH></TR><TR><TD>IM23456</TD><TD><BR /></TD></TR><TR><TD>IM26788</TD><TD><BR /></TD></TR><TR><TD>IM74777</TD><TD>IM78789</TD></TR><TR><TD>IM34677</TD><TD><BR /></TD></TR><TR><TD>IM98789</TD><TD><BR /></TD></TR><TR><TD>IM44323</TD><TD>IM98767</TD></TR></TBODY></TABLE><P></P><P></P><P>The idea is to count and show in a graphic only the elements in ID field that don´t have any data in ID Padre field, for the example would be 4 ID because i have 2 Items with data in ID Padre field.</P><P></P><P>How can i make this?</P></BODY></HTML> Fri, 05 Aug 2011 21:39:56 GMT https://community.qlik.com/t5/QlikView/How-to-discard-some-fields-to-make-count/m-p/254204#M586055 2011-08-05T21:39:56Z Re: How to discard some fields to make count? https://community.qlik.com/t5/QlikView/How-to-discard-some-fields-to-make-count/m-p/254205#M586056 <HTML><HEAD></HEAD><BODY><P>Maybe this?</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">count(if(len("ID Padre")=0,ID))</SPAN></P></BODY></HTML> Fri, 05 Aug 2011 22:04:41 GMT https://community.qlik.com/t5/QlikView/How-to-discard-some-fields-to-make-count/m-p/254205#M586056 johnw 2011-08-05T22:04:41Z How to discard some fields to make count? https://community.qlik.com/t5/QlikView/How-to-discard-some-fields-to-make-count/m-p/254206#M586057 <HTML><HEAD></HEAD><BODY><P>!Thanks for your great help¡</P></BODY></HTML> Fri, 05 Aug 2011 22:39:55 GMT https://community.qlik.com/t5/QlikView/How-to-discard-some-fields-to-make-count/m-p/254206#M586057 2011-08-05T22:39:55Z