topic Simple count of rows in QlikView

topic Simple count of rows in QlikView https://community.qlik.com/t5/QlikView/Simple-count-of-rows/m-p/405768#M566102 <HTML><HEAD></HEAD><BODY><P>I have the following data from the status logs:</P><P></P><P>Assume today is Dec 4th</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: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Date</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Status</STRONG></SPAN></TH></TR><TR><TD>A</TD><TD>12/4/2012</TD><TD>Docs Received</TD></TR><TR><TD>A</TD><TD>12/3/2012</TD><TD>Docs Sent</TD></TR><TR><TD>A</TD><TD>12/2/2012</TD><TD>Docs Requested</TD></TR><TR><TD>B</TD><TD>12/2/2012</TD><TD>Docs Sent</TD></TR><TR><TD>B</TD><TD>11/1/2012</TD><TD>Docs Requested</TD></TR><TR><TD>C</TD><TD>12/4/2012</TD><TD>Docs Requested</TD></TR><TR><TD>D</TD><TD>12/3/2012</TD><TD>Docs Requested</TD></TR></TBODY></TABLE><P></P><P></P><P>How can I get the counts as in below report?</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: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Status</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>As of Yesterday</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Additions</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Substraction</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>As of Today</STRONG></SPAN></TH></TR><TR><TD>Docs Received</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>Docs Sent</TD><TD>2</TD><TD>0</TD><TD>1</TD><TD>1</TD></TR><TR><TD>Docs Requested</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>2</TD></TR></TBODY></TABLE><P></P><P>Thanks,</P><P>Dinesh.</P></BODY></HTML> Tue, 04 Dec 2012 16:04:34 GMT Anonymous 2012-12-04T16:04:34Z Simple count of rows https://community.qlik.com/t5/QlikView/Simple-count-of-rows/m-p/405768#M566102 <HTML><HEAD></HEAD><BODY><P>I have the following data from the status logs:</P><P></P><P>Assume today is Dec 4th</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: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Date</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Status</STRONG></SPAN></TH></TR><TR><TD>A</TD><TD>12/4/2012</TD><TD>Docs Received</TD></TR><TR><TD>A</TD><TD>12/3/2012</TD><TD>Docs Sent</TD></TR><TR><TD>A</TD><TD>12/2/2012</TD><TD>Docs Requested</TD></TR><TR><TD>B</TD><TD>12/2/2012</TD><TD>Docs Sent</TD></TR><TR><TD>B</TD><TD>11/1/2012</TD><TD>Docs Requested</TD></TR><TR><TD>C</TD><TD>12/4/2012</TD><TD>Docs Requested</TD></TR><TR><TD>D</TD><TD>12/3/2012</TD><TD>Docs Requested</TD></TR></TBODY></TABLE><P></P><P></P><P>How can I get the counts as in below report?</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: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Status</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>As of Yesterday</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Additions</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Substraction</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: left;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>As of Today</STRONG></SPAN></TH></TR><TR><TD>Docs Received</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>Docs Sent</TD><TD>2</TD><TD>0</TD><TD>1</TD><TD>1</TD></TR><TR><TD>Docs Requested</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>2</TD></TR></TBODY></TABLE><P></P><P>Thanks,</P><P>Dinesh.</P></BODY></HTML> Tue, 04 Dec 2012 16:04:34 GMT https://community.qlik.com/t5/QlikView/Simple-count-of-rows/m-p/405768#M566102 Anonymous 2012-12-04T16:04:34Z