topic Re: Please Help Count/Distinct Count in QlikView https://community.qlik.com/t5/QlikView/Please-Help-Count-Distinct-Count/m-p/904483#M314491 <HTML><HEAD></HEAD><BODY><P>it seems already answered</P><P><A href="https://community.qlik.com/thread/170094">Please Help Count/Distinct Count</A></P></BODY></HTML> Thu, 25 Jun 2015 21:05:53 GMT maxgro 2015-06-25T21:05:53Z Please Help Count/Distinct Count https://community.qlik.com/t5/QlikView/Please-Help-Count-Distinct-Count/m-p/904482#M314490 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table with two columns (see below)</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Item</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Status</TH></TR><TR><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">123</TD><TD style="padding: 2px;">0</TD></TR><TR><TD style="padding: 2px;">32</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">12</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">0</TD></TR></TBODY></TABLE><P></P><P>I need to calculate the total number of <STRONG>distinct items </STRONG> and also calculate total number of completed Distinct items (Status = 1) </P><P></P><P><STRONG>eventually i need a percentage representation.</STRONG> </P><P></P><P>Please help me figure this requirement. Thank you for your time and help.</P><P></P><P>Best,</P><P>Nik</P></BODY></HTML> Thu, 25 Jun 2015 20:54:13 GMT https://community.qlik.com/t5/QlikView/Please-Help-Count-Distinct-Count/m-p/904482#M314490 2015-06-25T20:54:13Z Re: Please Help Count/Distinct Count https://community.qlik.com/t5/QlikView/Please-Help-Count-Distinct-Count/m-p/904483#M314491 <HTML><HEAD></HEAD><BODY><P>it seems already answered</P><P><A href="https://community.qlik.com/thread/170094">Please Help Count/Distinct Count</A></P></BODY></HTML> Thu, 25 Jun 2015 21:05:53 GMT https://community.qlik.com/t5/QlikView/Please-Help-Count-Distinct-Count/m-p/904483#M314491 maxgro 2015-06-25T21:05:53Z