topic Get your thinking caps on! Want to chart clockin/outs and time between in App Development https://community.qlik.com/t5/App-Development/Get-your-thinking-caps-on-Want-to-chart-clockin-outs-and-time/m-p/1345773#M29793 <HTML><HEAD></HEAD><BODY><P>Hello All, This is one where i think we can all work together on: I have created a solution in excel, but i want to take it into qlik.</P><P></P><P>I want to count the number of employees working every half hour (or a designated time increment) by when they clocked in and out.</P><P>Example:</P><P>Date Set</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Employee ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Time Stamp In</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Time Stamp Out</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1/7/17 8:00</TD><TD style="padding: 2px;">1/7/17 23:00</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1/7/8:00</TD><TD style="padding: 2px;">1/7/17 15:00</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">1/7/10:00</TD><TD style="padding: 2px;">1/7/1714:00</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>Things to consider: Want to be able to filter by day of week and if the time goes over midnight to the next day need to assign remaining hours to the next day or days. </P><P></P><P>Lets do this!!</P><P></P><P>Bill</P></BODY></HTML> Fri, 26 May 2017 16:17:36 GMT billuran 2017-05-26T16:17:36Z Get your thinking caps on! Want to chart clockin/outs and time between https://community.qlik.com/t5/App-Development/Get-your-thinking-caps-on-Want-to-chart-clockin-outs-and-time/m-p/1345773#M29793 <HTML><HEAD></HEAD><BODY><P>Hello All, This is one where i think we can all work together on: I have created a solution in excel, but i want to take it into qlik.</P><P></P><P>I want to count the number of employees working every half hour (or a designated time increment) by when they clocked in and out.</P><P>Example:</P><P>Date Set</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Employee ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Time Stamp In</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Time Stamp Out</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1/7/17 8:00</TD><TD style="padding: 2px;">1/7/17 23:00</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1/7/8:00</TD><TD style="padding: 2px;">1/7/17 15:00</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">1/7/10:00</TD><TD style="padding: 2px;">1/7/1714:00</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>Things to consider: Want to be able to filter by day of week and if the time goes over midnight to the next day need to assign remaining hours to the next day or days. </P><P></P><P>Lets do this!!</P><P></P><P>Bill</P></BODY></HTML> Fri, 26 May 2017 16:17:36 GMT https://community.qlik.com/t5/App-Development/Get-your-thinking-caps-on-Want-to-chart-clockin-outs-and-time/m-p/1345773#M29793 billuran 2017-05-26T16:17:36Z Re: Get your thinking caps on! Want to chart clockin/outs and time between https://community.qlik.com/t5/App-Development/Get-your-thinking-caps-on-Want-to-chart-clockin-outs-and-time/m-p/1345774#M29794 <HTML><HEAD></HEAD><BODY><P>Looks like you need to use the IntervalMatch() function as described here by HIC.</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/3037">IntervalMatch</A></P><P></P><P>You'll need to adjust things so it uses 30 minute buckets instead of whole day [24 hour] buckets.</P></BODY></HTML> Fri, 26 May 2017 16:23:33 GMT https://community.qlik.com/t5/App-Development/Get-your-thinking-caps-on-Want-to-chart-clockin-outs-and-time/m-p/1345774#M29794 Anonymous 2017-05-26T16:23:33Z