topic hour and min comparision in QlikView https://community.qlik.com/t5/QlikView/hour-and-min-comparision/m-p/100118#M15949 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Can anyone please let me know your suggestions on the attached qvw. All the details are provided in the attachment..</P><P></P><P>Thanks in advance.</P></BODY></HTML> Fri, 12 Oct 2018 12:32:11 GMT lavanya14 2018-10-12T12:32:11Z hour and min comparision https://community.qlik.com/t5/QlikView/hour-and-min-comparision/m-p/100118#M15949 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Can anyone please let me know your suggestions on the attached qvw. All the details are provided in the attachment..</P><P></P><P>Thanks in advance.</P></BODY></HTML> Fri, 12 Oct 2018 12:32:11 GMT https://community.qlik.com/t5/QlikView/hour-and-min-comparision/m-p/100118#M15949 lavanya14 2018-10-12T12:32:11Z Re: hour and min comparision https://community.qlik.com/t5/QlikView/hour-and-min-comparision/m-p/100119#M15950 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>Sum(Aggr(If(frac(Min(TIME)) &gt;= MakeTime(18, 00),</STRONG></P><P><STRONG>If(frac(Max(TIME)) &gt;= MakeTime(22, 00) and frac(Max(TIME)) &lt;=&nbsp; MakeTime(01, 15), 45,</STRONG></P><P><STRONG>If(frac(Max(TIME)) &gt;= MakeTime(02, 00) and frac(Max(TIME)) &lt;=&nbsp; MakeTime(05, 15), 90,</STRONG></P><P><STRONG>If(frac(Max(TIME)) &gt;= MakeTime(05, 15) and frac(Max(TIME)) &lt;=&nbsp; MakeTime(06, 00), 135)))), CARRIER, [EQP NAME]))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/215777_Capture.PNG" style="height: 127px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Fri, 12 Oct 2018 12:50:56 GMT https://community.qlik.com/t5/QlikView/hour-and-min-comparision/m-p/100119#M15950 sunny_talwar 2018-10-12T12:50:56Z