Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stabben23
Partner - Master
Partner - Master

Group a mismatched schedule

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.

   

DatestarttimeEndtimeScheduleID
2018-03-0419:0020:4518
2018-03-0421:0023:5918
2018-03-0500:0006:3017
2018-03-0522:4823:5917
2018-03-0600:0006:3017
2018-03-0622:4823:5917
2018-03-0700:0006:3017
2018-03-0722:4823:5917
2018-03-0800:0006:3019
Expected
2018-03-0419:002018-03-0506:30
2018-03-0522:482018-03-0606:30
2018-03-0622:482018-03-0706:30
2018-03-0722:482018-03-0806:30
2 Replies
YoussefBelloum
Champion
Champion

Hi,

what is the logic here to have this expected result?

what is the calculation rules ?

stabben23
Partner - Master
Partner - Master
Author

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.