topic How to count only one activity in QlikView https://community.qlik.com/t5/QlikView/How-to-count-only-one-activity/m-p/382671#M142833 <HTML><HEAD></HEAD><BODY><P>I have a database like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Equipment</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Activity</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Start Time.</STRONG></SPAN></TH></TR><TR><TD>WILMAR BERNAL</TD><TD>23/08/2012</TD><TD>BOGOTA 1</TD><TD> M.P</TD><TD> 22:00 </TD></TR><TR><TD>HELMAN MAHECHA</TD><TD>23/08/2012</TD><TD>BOGOTA 1</TD><TD>M.P</TD><TD> 23:00</TD></TR><TR><TD>HELMAN MAHECHA</TD><TD>24/08/2012</TD><TD>BOGOTA 2</TD><TD>EMERGENCY</TD><TD>10:00</TD></TR><TR><TD>WILMAR BERNAL</TD><TD>25/08/2012</TD><TD>BOGOTA 2</TD><TD>EMERGENCY</TD><TD>10:30</TD></TR></TBODY></TABLE><P></P><P></P><P>Based on the table, i need to count the number of activities, but to do that is necesary compare diferent columns, for example if the EQUIPMENT column, the ACTIVITY column, and the DATE column are equal for diferent items from NAME column, only count 1 Activity on a Chart, for example in the table above, the count of M.P in BOGOTA1 at August 23th must be one.</P><P></P><P>How can i do that?</P><P></P><P>Sorry for my english.</P></BODY></HTML> Thu, 30 Aug 2012 20:27:51 GMT 2012-08-30T20:27:51Z How to count only one activity https://community.qlik.com/t5/QlikView/How-to-count-only-one-activity/m-p/382671#M142833 <HTML><HEAD></HEAD><BODY><P>I have a database like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Equipment</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Activity</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Start Time.</STRONG></SPAN></TH></TR><TR><TD>WILMAR BERNAL</TD><TD>23/08/2012</TD><TD>BOGOTA 1</TD><TD> M.P</TD><TD> 22:00 </TD></TR><TR><TD>HELMAN MAHECHA</TD><TD>23/08/2012</TD><TD>BOGOTA 1</TD><TD>M.P</TD><TD> 23:00</TD></TR><TR><TD>HELMAN MAHECHA</TD><TD>24/08/2012</TD><TD>BOGOTA 2</TD><TD>EMERGENCY</TD><TD>10:00</TD></TR><TR><TD>WILMAR BERNAL</TD><TD>25/08/2012</TD><TD>BOGOTA 2</TD><TD>EMERGENCY</TD><TD>10:30</TD></TR></TBODY></TABLE><P></P><P></P><P>Based on the table, i need to count the number of activities, but to do that is necesary compare diferent columns, for example if the EQUIPMENT column, the ACTIVITY column, and the DATE column are equal for diferent items from NAME column, only count 1 Activity on a Chart, for example in the table above, the count of M.P in BOGOTA1 at August 23th must be one.</P><P></P><P>How can i do that?</P><P></P><P>Sorry for my english.</P></BODY></HTML> Thu, 30 Aug 2012 20:27:51 GMT https://community.qlik.com/t5/QlikView/How-to-count-only-one-activity/m-p/382671#M142833 2012-08-30T20:27:51Z Re: How to count only one activity https://community.qlik.com/t5/QlikView/How-to-count-only-one-activity/m-p/382672#M142834 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Check with this</P><P>Count(Distinct <STRONG style="background-color: #6690bc; font-size: 12px; color: #ffffff; font-family: Arial; text-align: -webkit-center;">Date</STRONG>&amp;<STRONG style="background-color: #6690bc; font-size: 12px; color: #ffffff; font-family: Arial; text-align: -webkit-center;">Equipment</STRONG>&amp;<STRONG style="background-color: #6690bc; font-size: 12px; color: #ffffff; font-family: Arial; text-align: -webkit-center;">Activity</STRONG>)</P><P></P><P>Celambarasan</P></BODY></HTML> Thu, 30 Aug 2012 20:52:42 GMT https://community.qlik.com/t5/QlikView/How-to-count-only-one-activity/m-p/382672#M142834 CELAMBARASAN 2012-08-30T20:52:42Z Re: How to count only one activity https://community.qlik.com/t5/QlikView/How-to-count-only-one-activity/m-p/382673#M142835 <HTML><HEAD></HEAD><BODY><P>Thanks a lot, that was a very good solution.</P><P></P><P>Best Regards from Colombia.</P></BODY></HTML> Thu, 30 Aug 2012 21:26:10 GMT https://community.qlik.com/t5/QlikView/How-to-count-only-one-activity/m-p/382673#M142835 2012-08-30T21:26:10Z Re: How to count only one activity https://community.qlik.com/t5/QlikView/How-to-count-only-one-activity/m-p/382674#M142836 <HTML><HEAD></HEAD><BODY><P>Thanks a lot, that was a very good solution.</P><P></P><P>Best Regards from Colombia.</P></BODY></HTML> Thu, 30 Aug 2012 21:26:25 GMT https://community.qlik.com/t5/QlikView/How-to-count-only-one-activity/m-p/382674#M142836 2012-08-30T21:26:25Z