Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for
Did you mean:
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..

1 Solution

Accepted Solutions
MVP

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

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]))

Community Browser