topic Re: Aggr Count by Dimension Question in QlikView https://community.qlik.com/t5/QlikView/Aggr-Count-by-Dimension-Question/m-p/1010970#M468519 <HTML><HEAD></HEAD><BODY><P>see attached:</P><P></P><P><IMG alt="Capture1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/97184_Capture1.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 27 Aug 2015 15:30:45 GMT Qrishna 2015-08-27T15:30:45Z Aggr Count by Dimension Question https://community.qlik.com/t5/QlikView/Aggr-Count-by-Dimension-Question/m-p/1010968#M468517 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How do I count the half_hr_bucket by date? I tried this expression but it does not return anything. Please help!</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Aggr(count(<SPAN style="font-size: 13.3333330154419px;">half_hr_bucket</SPAN>),date)</STRONG></SPAN></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="247"><TBODY><TR><TD class="xl68" height="20" width="133">date</TD><TD class="xl69" style="border-left: none;" width="114">half_hr_bucket</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/2/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">09:00 - 09:30</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/2/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">09:30 - 10:00</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/2/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">10:00 - 10:30</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/2/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">10:30 - 11:00</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/2/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">11:00 - 11:30</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/5/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">13:30 - 14:00</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/5/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">14:00 - 14:30</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/5/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">14:30 - 15:00</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/5/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">15:00 - 15:30</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/5/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">15:30 - 16:00</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/5/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">16:00 - 16:30</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/5/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">16:30 - 17:00</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/5/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">17:00 - 17:30</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/5/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">17:30 - 18:00</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/6/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">09:00 - 09:30</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/6/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">09:30 - 10:00</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/6/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">10:00 - 10:30</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/6/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">10:30 - 11:00</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/6/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">11:00 - 11:30</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/6/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">11:30 - 12:00</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/7/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">14:00 - 14:30</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/7/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">14:30 - 15:00</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/7/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">15:00 - 15:30</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/7/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">15:30 - 16:00</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/7/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">16:00 - 16:30</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/7/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">16:30 - 17:00</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/7/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">17:00 - 17:30</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">1/7/2015</TD><TD class="xl67" style="border-top: none; border-left: none;">17:30 - 18:00</TD></TR></TBODY></TABLE><P></P><P></P><P>Thank you for your inputs.</P></BODY></HTML> Thu, 27 Aug 2015 14:37:34 GMT https://community.qlik.com/t5/QlikView/Aggr-Count-by-Dimension-Question/m-p/1010968#M468517 2015-08-27T14:37:34Z Re: Aggr Count by Dimension Question https://community.qlik.com/t5/QlikView/Aggr-Count-by-Dimension-Question/m-p/1010969#M468518 <HTML><HEAD></HEAD><BODY><P>is this in a straight table ?</P><P></P><P>you can use </P><P>=count(total &lt;<SPAN style="font-size: 13.3333330154419px;">date</SPAN>&gt; half_hr_bucket)</P></BODY></HTML> Thu, 27 Aug 2015 15:18:10 GMT https://community.qlik.com/t5/QlikView/Aggr-Count-by-Dimension-Question/m-p/1010969#M468518 ramoncova06 2015-08-27T15:18:10Z Re: Aggr Count by Dimension Question https://community.qlik.com/t5/QlikView/Aggr-Count-by-Dimension-Question/m-p/1010970#M468519 <HTML><HEAD></HEAD><BODY><P>see attached:</P><P></P><P><IMG alt="Capture1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/97184_Capture1.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 27 Aug 2015 15:30:45 GMT https://community.qlik.com/t5/QlikView/Aggr-Count-by-Dimension-Question/m-p/1010970#M468519 Qrishna 2015-08-27T15:30:45Z Re: Aggr Count by Dimension Question https://community.qlik.com/t5/QlikView/Aggr-Count-by-Dimension-Question/m-p/1010971#M468520 <HTML><HEAD></HEAD><BODY><P>@ Krishna: I used your expression and made small change and it worked for me now. Thank you!</P><P>@Ramon: Thank you for your reply.</P></BODY></HTML> Thu, 27 Aug 2015 18:23:04 GMT https://community.qlik.com/t5/QlikView/Aggr-Count-by-Dimension-Question/m-p/1010971#M468520 2015-08-27T18:23:04Z Re: Aggr Count by Dimension Question https://community.qlik.com/t5/QlikView/Aggr-Count-by-Dimension-Question/m-p/1010972#M468521 <HTML><HEAD></HEAD><BODY><P>Awesome. Please close the thread as 'Answered'</P></BODY></HTML> Thu, 27 Aug 2015 18:24:56 GMT https://community.qlik.com/t5/QlikView/Aggr-Count-by-Dimension-Question/m-p/1010972#M468521 Qrishna 2015-08-27T18:24:56Z