topic Sums for expression in straight table? in QlikView https://community.qlik.com/t5/QlikView/Sums-for-expression-in-straight-table/m-p/351885#M130517 <HTML><HEAD></HEAD><BODY><DIV><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>SalesName</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Customer</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Start Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Action Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Quick</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Medium</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Long</STRONG></SPAN></TH></TR><TR><TD><P>Jack</P></TD><TD>ABC</TD><TD>1/5/2012</TD><TD>1/6/2012</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Jack</TD><TD>ABC</TD><TD>1/5/2012</TD><TD>1/25/2012</TD><TD>0</TD><TD>0</TD><TD>1</TD></TR><TR><TD>Jill</TD><TD>XYZ</TD><TD>1/5/2012</TD><TD>1/5/2012</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Jill</TD><TD>XYZ</TD><TD>1/5/2012</TD><TD>1/6/2012</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Jack</TD><TD>ABC</TD><TD>1/15/2012</TD><TD>1/25/2012</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>James</TD><TD>BBB</TD><TD>1/15/2012</TD><TD>1/29/2012</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR></TBODY></TABLE>Here's my issue: I have a group of ten salespeople. I want to measure how quickly they respond when they get a lead. I have a straight table, as shown above. The fields "Quick", "Medium", and "Long" are calculated using an expression (NetWorkDays). I want, for each rep, to do a count distinct of company, a count distinct of Start Date per company, and a count of Quick, Medium, and Long. This will, I hope, tell me for each rep the number of companies they are working, the number of opportunities they have, and how many total calls they have made that fall into each of the Quick, medium, and long buckets. I've tried doing this as a pivot table, but it won't let me sum on the expressions, and when I tried a partial sum for Company, it didn't show any sums for Quick, Medium, or Long. I should think this would be simple - it'd take me a minute in Excel - but clearly I'm missing something here. Any help?<DIV><DIV> </DIV></DIV></DIV></BODY></HTML> Wed, 13 Jun 2012 18:48:02 GMT 2012-06-13T18:48:02Z Sums for expression in straight table? https://community.qlik.com/t5/QlikView/Sums-for-expression-in-straight-table/m-p/351885#M130517 <HTML><HEAD></HEAD><BODY><DIV><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>SalesName</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Customer</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Start Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Action Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Quick</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Medium</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Long</STRONG></SPAN></TH></TR><TR><TD><P>Jack</P></TD><TD>ABC</TD><TD>1/5/2012</TD><TD>1/6/2012</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Jack</TD><TD>ABC</TD><TD>1/5/2012</TD><TD>1/25/2012</TD><TD>0</TD><TD>0</TD><TD>1</TD></TR><TR><TD>Jill</TD><TD>XYZ</TD><TD>1/5/2012</TD><TD>1/5/2012</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Jill</TD><TD>XYZ</TD><TD>1/5/2012</TD><TD>1/6/2012</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Jack</TD><TD>ABC</TD><TD>1/15/2012</TD><TD>1/25/2012</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>James</TD><TD>BBB</TD><TD>1/15/2012</TD><TD>1/29/2012</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR></TBODY></TABLE>Here's my issue: I have a group of ten salespeople. I want to measure how quickly they respond when they get a lead. I have a straight table, as shown above. The fields "Quick", "Medium", and "Long" are calculated using an expression (NetWorkDays). I want, for each rep, to do a count distinct of company, a count distinct of Start Date per company, and a count of Quick, Medium, and Long. This will, I hope, tell me for each rep the number of companies they are working, the number of opportunities they have, and how many total calls they have made that fall into each of the Quick, medium, and long buckets. I've tried doing this as a pivot table, but it won't let me sum on the expressions, and when I tried a partial sum for Company, it didn't show any sums for Quick, Medium, or Long. I should think this would be simple - it'd take me a minute in Excel - but clearly I'm missing something here. Any help?<DIV><DIV> </DIV></DIV></DIV></BODY></HTML> Wed, 13 Jun 2012 18:48:02 GMT https://community.qlik.com/t5/QlikView/Sums-for-expression-in-straight-table/m-p/351885#M130517 2012-06-13T18:48:02Z