Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

stabben23
Honored Contributor

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
Esteemed Contributor

Re: Group a mismatched schedule

Hi,

what is the logic here to have this expected result?

what is the calculation rules ?

stabben23
Honored Contributor

Re: Group a mismatched schedule

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.

Community Browser