topic Re: Count from last timestamp? in QlikView https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409014#M1166926 <HTML><HEAD></HEAD><BODY><P>try:</P><P></P><P>count(aggr(max(TIMESTAMP),ID,LEVEL,RISK))</P></BODY></HTML> Fri, 12 Oct 2012 14:37:12 GMT 2012-10-12T14:37:12Z Count from last timestamp? https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409013#M1166925 <HTML><HEAD></HEAD><BODY><P>How do you create an expression to get a count of last timestamp of ID for each LEVEL and RISK from the table below? </P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 40%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>TIMESTAMP</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>LEVEL</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>RISK</STRONG></SPAN></TH></TR><TR><TD>7/23/2012</TD><TD>1264</TD><TD>9</TD><TD>6</TD></TR><TR><TD>7/24/2012</TD><TD>1288</TD><TD>9</TD><TD>5</TD></TR><TR><TD>7/24/2012</TD><TD>1357</TD><TD>2</TD><TD>6</TD></TR><TR><TD style="TEXT-ALIGN: left;"><SPAN style="color: #ff0000;">7/24/2012</SPAN></TD><TD style="TEXT-ALIGN: left;"><SPAN style="color: #ff0000;">1357</SPAN></TD><TD style="TEXT-ALIGN: left;"><SPAN style="color: #ff0000;">2</SPAN></TD><TD style="TEXT-ALIGN: left;"><SPAN style="color: #ff0000;">6</SPAN></TD></TR><TR><TD><SPAN style="color: #333333;">7/24/2012</SPAN></TD><TD><SPAN style="color: #333333;">1833</SPAN></TD><TD><SPAN style="color: #333333;">1</SPAN></TD><TD><SPAN style="color: #333333;">6</SPAN></TD></TR><TR><TD><SPAN style="color: #ff0000;">7/25/2012</SPAN></TD><TD><SPAN style="color: #ff0000;">1366</SPAN></TD><TD><SPAN style="color: #ff0000;">2</SPAN></TD><TD><SPAN style="color: #ff0000;">6</SPAN></TD></TR><TR><TD><SPAN style="color: #333333;">7/26/2012</SPAN></TD><TD><SPAN style="color: #333333;">1222</SPAN></TD><TD><SPAN style="color: #333333;">9</SPAN></TD><TD><SPAN style="color: #333333;">4</SPAN></TD></TR><TR><TD><SPAN style="color: #333333;">7/27/2012</SPAN></TD><TD><SPAN style="color: #333333;">1222</SPAN></TD><TD><SPAN style="color: #333333;">3</SPAN></TD><TD><SPAN style="color: #333333;">6</SPAN></TD></TR><TR><TD><SPAN style="color: #333333;">7/28/2012</SPAN></TD><TD><SPAN style="color: #333333;">2889</SPAN></TD><TD><SPAN style="color: #333333;">2</SPAN></TD><TD><SPAN style="color: #333333;">6</SPAN></TD></TR><TR><TD><SPAN style="color: #ff0000;">7/30/2012</SPAN></TD><TD><SPAN style="color: #ff0000;">2889</SPAN></TD><TD><SPAN style="color: #ff0000;">2</SPAN></TD><TD><SPAN style="color: #ff0000;">6</SPAN></TD></TR><TR><TD><SPAN style="color: #ff0000;">7/31/2012</SPAN></TD><TD><SPAN style="color: #ff0000;">6777</SPAN></TD><TD><SPAN style="color: #ff0000;">2</SPAN></TD><TD><SPAN style="color: #ff0000;">6</SPAN></TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>I would expect to get the following counts:</P><P>LEVEL=1 RISK=6 ====&gt; COUNT=1</P><P>LEVEL=2 RISK=6 ====&gt; COUNT=4</P><P>etc...</P></BODY></HTML> Fri, 12 Oct 2012 13:44:50 GMT https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409013#M1166925 2012-10-12T13:44:50Z Re: Count from last timestamp? https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409014#M1166926 <HTML><HEAD></HEAD><BODY><P>try:</P><P></P><P>count(aggr(max(TIMESTAMP),ID,LEVEL,RISK))</P></BODY></HTML> Fri, 12 Oct 2012 14:37:12 GMT https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409014#M1166926 2012-10-12T14:37:12Z Re: Count from last timestamp? https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409015#M1166927 <HTML><HEAD></HEAD><BODY><P>I need to add one more step, how would I update this expression if I wanted to count only if LEVEL=2?</P></BODY></HTML> Sat, 13 Oct 2012 03:19:38 GMT https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409015#M1166927 2012-10-13T03:19:38Z Re: Count from last timestamp? https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409016#M1166928 <HTML><HEAD></HEAD><BODY><P>try: count(aggr(max({$&lt;[LEVEL]={'2'}&gt;} TIMESTAMP),ID,LEVEL,RISK))</P></BODY></HTML> Sat, 13 Oct 2012 10:02:11 GMT https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409016#M1166928 Gysbert_Wassenaar 2012-10-13T10:02:11Z Re: Count from last timestamp? https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409017#M1166930 <HTML><HEAD></HEAD><BODY><P>Thank you this works now!</P></BODY></HTML> Sat, 13 Oct 2012 13:02:44 GMT https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409017#M1166930 2012-10-13T13:02:44Z Re: Count from last timestamp? https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409018#M1166933 <HTML><HEAD></HEAD><BODY><P>Thank you this works now!</P></BODY></HTML> Sat, 13 Oct 2012 13:02:51 GMT https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409018#M1166933 2012-10-13T13:02:51Z Re: Count from last timestamp? https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409019#M1166934 <HTML><HEAD></HEAD><BODY><P>Thank you this works now!</P></BODY></HTML> Sat, 13 Oct 2012 13:04:21 GMT https://community.qlik.com/t5/QlikView/Count-from-last-timestamp/m-p/409019#M1166934 2012-10-13T13:04:21Z