topic Re: I want Day & Night Employee Shift time in QV in QlikView https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032439#M924074 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">If(Frac(FieldName) &gt;= MakeTime(8) and Frac(FieldName) &lt; MakeTime(14), 'Early',</STRONG></P><P><STRONG style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">If(<STRONG style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Frac(FieldName) &gt;= MakeTime(14) and Frac(FieldName) &lt; MakeTime(20), 'Late', </STRONG>'Night')) as Flag</STRONG></P></BODY></HTML> Tue, 19 Sep 2017 11:18:57 GMT sunny_talwar 2017-09-19T11:18:57Z I want Day & Night Employee Shift time in QV https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032432#M924067 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want Day flag &amp; Night flag</P><P>My Day Shift Starts :</P><P><SPAN class="aBn" data-term="goog_256004603"><SPAN class="aQJ">9.00 AM to 7.00 PM</SPAN></SPAN></P><P>My Night Shift Starts :</P><P><SPAN class="aBn" data-term="goog_256004604"><SPAN class="aQJ">7.01 PM to 8.59 AM</SPAN></SPAN></P><P>Please send me script level code of this as soon as possible.</P><P></P><P>If i select Day : All records which lies in day shift is should come in DAY.</P><P>If i select Night : All records which lies in Night shift is should come in Night.</P><P></P><P>Regards</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032432#M924067 2020-11-25T16:16:04Z Re: I want Day & Night Employee Shift time in QV https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032433#M924068 <HTML><HEAD></HEAD><BODY><P>Can you share the sample data?</P></BODY></HTML> Thu, 14 Apr 2016 10:49:05 GMT https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032433#M924068 Kushal_Chawda 2016-04-14T10:49:05Z Re: I want Day & Night Employee Shift time in QV https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032434#M924069 <HTML><HEAD></HEAD><BODY><P>May be create a flag in your fact table:</P><P></P><P><STRONG style="text-decoration: line-through;">If(Hour(FieldName) &gt;= MakeTime(9) and Hour(FieldName) &lt;= MakeTime(19), 'Day', 'Night') as Flag</STRONG></P><P></P><P><STRONG style="font-size: 13.3333px;">If(Hour(FieldName) &gt;= MakeTime(9) and Hour(FieldName) &lt; MakeTime(19), 'Day', 'Night') as Flag</STRONG></P></BODY></HTML> Thu, 14 Apr 2016 11:01:36 GMT https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032434#M924069 sunny_talwar 2016-04-14T11:01:36Z Re: I want Day & Night Employee Shift time in QV https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032435#M924070 <HTML><HEAD></HEAD><BODY><P>Or this:</P><P></P><P><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>If(Frac(FieldName) &gt;= MakeTime(9) and Frac(FieldName) &lt;= MakeTime(19), 'Day', 'Night') as Flag</STRONG></SPAN></P></BODY></HTML> Thu, 14 Apr 2016 11:03:50 GMT https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032435#M924070 sunny_talwar 2016-04-14T11:03:50Z Re: I want Day & Night Employee Shift time in QV https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032436#M924071 <HTML><HEAD></HEAD><BODY><P>Do you require QVDs used data or Report data.</P></BODY></HTML> Thu, 14 Apr 2016 11:04:42 GMT https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032436#M924071 2016-04-14T11:04:42Z Re: I want Day & Night Employee Shift time in QV https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032437#M924072 <HTML><HEAD></HEAD><BODY><P>Just need to understand how your data look like and on what field you want to do the calculation? You can show the screenshot of your sample QVD data</P></BODY></HTML> Fri, 15 Apr 2016 05:45:39 GMT https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032437#M924072 Kushal_Chawda 2016-04-15T05:45:39Z Re: I want Day & Night Employee Shift time in QV https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032438#M924073 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Could I use this expression to create an Early, Late and Night Shift where the Early Shift runs from 08:00 to 13:59, Late runs from 14:00 to 19:59 and night runs from 20:00 to 07:59?</P><P></P><P>Many thanks,</P><P></P><P>Phil</P></BODY></HTML> Tue, 19 Sep 2017 09:07:32 GMT https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032438#M924073 prees959 2017-09-19T09:07:32Z Re: I want Day & Night Employee Shift time in QV https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032439#M924074 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">If(Frac(FieldName) &gt;= MakeTime(8) and Frac(FieldName) &lt; MakeTime(14), 'Early',</STRONG></P><P><STRONG style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">If(<STRONG style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Frac(FieldName) &gt;= MakeTime(14) and Frac(FieldName) &lt; MakeTime(20), 'Late', </STRONG>'Night')) as Flag</STRONG></P></BODY></HTML> Tue, 19 Sep 2017 11:18:57 GMT https://community.qlik.com/t5/QlikView/I-want-Day-Night-Employee-Shift-time-in-QV/m-p/1032439#M924074 sunny_talwar 2017-09-19T11:18:57Z