# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
New Contributor III

## hour and min comparision

Hi All,

Can anyone please let me know your suggestions on the attached qvw. All the details are provided in the attachment..

Tags (1)
1 Solution

Accepted Solutions MVP

## Re: hour and min comparision

Try this

Sum(Aggr(If(frac(Min(TIME)) >= MakeTime(18, 00),

If(frac(Max(TIME)) >= MakeTime(22, 00) and frac(Max(TIME)) <=  MakeTime(01, 15), 45,

If(frac(Max(TIME)) >= MakeTime(02, 00) and frac(Max(TIME)) <=  MakeTime(05, 15), 90,

If(frac(Max(TIME)) >= MakeTime(05, 15) and frac(Max(TIME)) <=  MakeTime(06, 00), 135)))), CARRIER, [EQP NAME]))  MVP

## Re: hour and min comparision

Try this

Sum(Aggr(If(frac(Min(TIME)) >= MakeTime(18, 00),

If(frac(Max(TIME)) >= MakeTime(22, 00) and frac(Max(TIME)) <=  MakeTime(01, 15), 45,

If(frac(Max(TIME)) >= MakeTime(02, 00) and frac(Max(TIME)) <=  MakeTime(05, 15), 90,

If(frac(Max(TIME)) >= MakeTime(05, 15) and frac(Max(TIME)) <=  MakeTime(06, 00), 135)))), CARRIER, [EQP NAME])) 