topic Group a mismatched schedule in QlikView

Group a mismatched schedule

stabben23 — Fri, 02 Mar 2018 13:09:49 GMT

Hi,

does someone have a Clue how I should solve this?

What I try to do is create a working schedule With these input.

script or frontend doesnt matter.

YoussefBelloum — Fri, 02 Mar 2018 13:50:25 GMT

Hi,

what is the logic here to have this expected result?

what is the calculation rules ?

stabben23 — Fri, 02 Mar 2018 14:18:17 GMT

Hi Youssef, I'll think Logic is what we have to find here, because there is any yet.

I have try to use if combinied With Group by.

like if ScheduleID is 18 then use the min value of starttime and if if ScheduleID is 17 it will use min of Endtime.