topic Re: ¿Count by range/shift (in hours) in date? in QlikView https://community.qlik.com/t5/QlikView/Count-by-range-shift-in-hours-in-date/m-p/1038054#M923136 <HTML><HEAD></HEAD><BODY><P>I'd create a shift field during the load of your data.</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;"> if(hour(Date)&lt;6,1</SPAN><BR /><SPAN style="font-family: courier new,courier;">,if(hour(Date)&lt;14,2</SPAN><BR /><SPAN style="font-family: courier new,courier;">,if(hour(Date)&lt;22,3,1))) as Shift</SPAN></P><P></P><P>Then use Shift as the dimension.</P></BODY></HTML> Thu, 14 Apr 2016 23:10:19 GMT johnw 2016-04-14T23:10:19Z ¿Count by range/shift (in hours) in date? https://community.qlik.com/t5/QlikView/Count-by-range-shift-in-hours-in-date/m-p/1038053#M923135 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I need to count the ID that are into the followings diferents shifts:</P><P></P><P>Shift 1&nbsp; 6:00 to 14:00</P><P>Shift 2&nbsp; 14:00 to 22:00</P><P>Shift 3&nbsp;&nbsp; 22:00 to 6:00</P><P></P><P>My source is like:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="232"><TBODY><TR><TD class="xl63" height="20" width="64">ID</TD><TD class="xl63" style="border-left: none;" width="168">Date</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">10/04/2016 06:00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">10/04/2016 08:00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">3</TD><TD class="xl65" style="border-top: none; border-left: none;">10/04/2016 12:00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">4</TD><TD class="xl65" style="border-top: none; border-left: none;">10/04/2016 14:00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">5</TD><TD class="xl65" style="border-top: none; border-left: none;">10/04/2016 18:00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">6</TD><TD class="xl65" style="border-top: none; border-left: none;">11/04/2016 05:00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">7</TD><TD class="xl65" style="border-top: none; border-left: none;">11/04/2016 10:00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">8</TD><TD class="xl65" style="border-top: none; border-left: none;">11/04/2016 22:00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">9</TD><TD class="xl65" style="border-top: none; border-left: none;">11/04/2016 23:00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">10</TD><TD class="xl65" style="border-top: none; border-left: none;">11/04/2016 03:00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">11</TD><TD class="xl65" style="border-top: none; border-left: none;">11/04/2016 01:00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">12</TD><TD class="xl65" style="border-top: none; border-left: none;">11/04/2016 01:00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">13</TD><TD class="xl65" style="border-top: none; border-left: none;">11/04/2016 04:00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">14</TD><TD class="xl65" style="border-top: none; border-left: none;">12/04/2016 14:00</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">15</TD><TD class="xl65" style="border-top: none; border-left: none;">12/04/2016 06:00</TD></TR></TBODY></TABLE><P></P><P>I need count shift by shift (diferent count)</P><P></P><P>Best regards.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Count-by-range-shift-in-hours-in-date/m-p/1038053#M923135 2020-11-25T16:16:04Z Re: ¿Count by range/shift (in hours) in date? https://community.qlik.com/t5/QlikView/Count-by-range-shift-in-hours-in-date/m-p/1038054#M923136 <HTML><HEAD></HEAD><BODY><P>I'd create a shift field during the load of your data.</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;"> if(hour(Date)&lt;6,1</SPAN><BR /><SPAN style="font-family: courier new,courier;">,if(hour(Date)&lt;14,2</SPAN><BR /><SPAN style="font-family: courier new,courier;">,if(hour(Date)&lt;22,3,1))) as Shift</SPAN></P><P></P><P>Then use Shift as the dimension.</P></BODY></HTML> Thu, 14 Apr 2016 23:10:19 GMT https://community.qlik.com/t5/QlikView/Count-by-range-shift-in-hours-in-date/m-p/1038054#M923136 johnw 2016-04-14T23:10:19Z