topic Re: Counting a comparison between SUM and COUNT Expression in QlikView https://community.qlik.com/t5/QlikView/Counting-a-comparison-between-SUM-and-COUNT-Expression/m-p/398637#M490962 <HTML><HEAD></HEAD><BODY><P>I'd recommend you upload sample data and files. It makes understanding the problem easier!</P><P></P><P>Regards</P><P>MultiView</P></BODY></HTML> Tue, 13 Nov 2012 13:59:16 GMT Anonymous 2012-11-13T13:59:16Z Counting a comparison between SUM and COUNT Expression https://community.qlik.com/t5/QlikView/Counting-a-comparison-between-SUM-and-COUNT-Expression/m-p/398635#M490960 <HTML><HEAD></HEAD><BODY><P>Hi, <BR />I've the foloowing problem.</P><P>I've a table with "Target" and "Sell" values divided by Seller and By Category</P><P></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>Seller</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Category</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><P><SPAN style="color: #ffffff;"><STRONG>Cat 01</STRONG></SPAN></P></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Cat 02</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Total</STRONG></SPAN></TH></TR><TR><TD>Seller 01</TD><TD>Sell</TD><TD>10</TD><TD>12</TD><TD>22</TD></TR><TR><TD><BR /></TD><TD>Target</TD><TD>15</TD><TD>10</TD><TD>25</TD></TR><TR><TD>Seller 02</TD><TD>Sell</TD><TD>5</TD><TD>6</TD><TD>11</TD></TR><TR><TD><BR /></TD><TD>Target</TD><TD>5</TD><TD>5</TD><TD>10</TD></TR></TBODY></TABLE><P></P><P>I would like to add a column (or row) saing How many target has been reached.<BR />I found&nbsp; that I could add "Target Reach" with "If (Sell&gt;target, 1, 0)" is working for the Cats columns, but not for the Total (the one I really need)</P><P></P><P>Please note that Sell&nbsp; = COUNT(ContractNr), and Target = SUM(Target)</P><P></P><P>Any idea?</P><P></P><P></P><P>Thank you</P></BODY></HTML> Wed, 12 Sep 2012 08:16:45 GMT https://community.qlik.com/t5/QlikView/Counting-a-comparison-between-SUM-and-COUNT-Expression/m-p/398635#M490960 2012-09-12T08:16:45Z Re: Counting a comparison between SUM and COUNT Expression https://community.qlik.com/t5/QlikView/Counting-a-comparison-between-SUM-and-COUNT-Expression/m-p/398636#M490961 <HTML><HEAD></HEAD><BODY><P>Sorry I forgto to add...</P><P></P><P>the results for Seller01 should then be 0, 1, 1<BR />for Seller 02 1, 1, 2</P></BODY></HTML> Wed, 12 Sep 2012 08:17:37 GMT https://community.qlik.com/t5/QlikView/Counting-a-comparison-between-SUM-and-COUNT-Expression/m-p/398636#M490961 2012-09-12T08:17:37Z Re: Counting a comparison between SUM and COUNT Expression https://community.qlik.com/t5/QlikView/Counting-a-comparison-between-SUM-and-COUNT-Expression/m-p/398637#M490962 <HTML><HEAD></HEAD><BODY><P>I'd recommend you upload sample data and files. It makes understanding the problem easier!</P><P></P><P>Regards</P><P>MultiView</P></BODY></HTML> Tue, 13 Nov 2012 13:59:16 GMT https://community.qlik.com/t5/QlikView/Counting-a-comparison-between-SUM-and-COUNT-Expression/m-p/398637#M490962 Anonymous 2012-11-13T13:59:16Z