topic count in QlikView

topic count in QlikView https://community.qlik.com/t5/QlikView/count/m-p/431512#M160891 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the following board</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 623px;"><TBODY><TR><TD class="xl63" height="17" width="90">HMCONT</TD><TD class="xl63" style="border-left: none;" width="146">CUSTO</TD><TD class="xl63" style="border-left: none;" width="125">TRANS</TD><TD class="xl63" style="border-left: none;" width="127">DATE MOV</TD><TD class="xl63" style="border-left: none;" width="108">DATE ENTREE</TD><TD class="xl63" style="border-left: none;" width="27">PEV</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">U6451156</TD><TD class="xl64" style="border-top: none; border-left: none;">CUSTO1</TD><TD class="xl64" style="border-top: none; border-left: none;">SV</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">10/01/2013</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">U6451156</TD><TD class="xl64" style="border-top: none; border-left: none;">CUSTO1</TD><TD class="xl64" style="border-top: none; border-left: none;">SV</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">U2520054</TD><TD class="xl64" style="border-top: none; border-left: none;">CUSTO1</TD><TD class="xl64" style="border-top: none; border-left: none;">SV</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">18/03/2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">10/01/2013</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">U2520054</TD><TD class="xl64" style="border-top: none; border-left: none;">CUSTO1</TD><TD class="xl64" style="border-top: none; border-left: none;">SV</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">U7000870</TD><TD class="xl64" style="border-top: none; border-left: none;">CUSTO1</TD><TD class="xl64" style="border-top: none; border-left: none;">SV</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">10/01/2013</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">U7000870</TD><TD class="xl64" style="border-top: none; border-left: none;">CUSTO1</TD><TD class="xl64" style="border-top: none; border-left: none;">SV</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD></TR></TBODY></TABLE><P></P><P></P><P>I use the function =count(distinct HMCONT) to do a sum of count column [PEV], for this example the total of [PEV] return = 3</P><P></P><P>But I need to count PEV 2 = 2 and 1 = 1 always for this example the result must be = 5</P><P></P><P>Someone have an idea how to do this operation?</P></BODY></HTML> Mon, 08 Apr 2013 11:53:13 GMT realpixel 2013-04-08T11:53:13Z count https://community.qlik.com/t5/QlikView/count/m-p/431512#M160891 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have the following board</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 623px;"><TBODY><TR><TD class="xl63" height="17" width="90">HMCONT</TD><TD class="xl63" style="border-left: none;" width="146">CUSTO</TD><TD class="xl63" style="border-left: none;" width="125">TRANS</TD><TD class="xl63" style="border-left: none;" width="127">DATE MOV</TD><TD class="xl63" style="border-left: none;" width="108">DATE ENTREE</TD><TD class="xl63" style="border-left: none;" width="27">PEV</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">U6451156</TD><TD class="xl64" style="border-top: none; border-left: none;">CUSTO1</TD><TD class="xl64" style="border-top: none; border-left: none;">SV</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">10/01/2013</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">U6451156</TD><TD class="xl64" style="border-top: none; border-left: none;">CUSTO1</TD><TD class="xl64" style="border-top: none; border-left: none;">SV</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">U2520054</TD><TD class="xl64" style="border-top: none; border-left: none;">CUSTO1</TD><TD class="xl64" style="border-top: none; border-left: none;">SV</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">18/03/2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">10/01/2013</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">U2520054</TD><TD class="xl64" style="border-top: none; border-left: none;">CUSTO1</TD><TD class="xl64" style="border-top: none; border-left: none;">SV</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">U7000870</TD><TD class="xl64" style="border-top: none; border-left: none;">CUSTO1</TD><TD class="xl64" style="border-top: none; border-left: none;">SV</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">10/01/2013</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">U7000870</TD><TD class="xl64" style="border-top: none; border-left: none;">CUSTO1</TD><TD class="xl64" style="border-top: none; border-left: none;">SV</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">19/03/2013</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD></TR></TBODY></TABLE><P></P><P></P><P>I use the function =count(distinct HMCONT) to do a sum of count column [PEV], for this example the total of [PEV] return = 3</P><P></P><P>But I need to count PEV 2 = 2 and 1 = 1 always for this example the result must be = 5</P><P></P><P>Someone have an idea how to do this operation?</P></BODY></HTML> Mon, 08 Apr 2013 11:53:13 GMT https://community.qlik.com/t5/QlikView/count/m-p/431512#M160891 realpixel 2013-04-08T11:53:13Z