Show if timeslots are 'occupied' from time range

c_gilbert — Mon, 08 Apr 2019 08:38:38 GMT

I was wondering if it's possible to have a 'start' and 'end' time and show if this range fell into certain time slots.

If I have a table with, for example, meeting room bookings.

Could this be converted to something like the below in QlikView? or would some transformation be required in SQL first?

07:00 < 07:15

07:15 < 07:30

07:30 < 07:45

07:45 < 08:00

08:00 < 08:15

08:15 < 08:30

08:30 < 08:45

08:45 < 09:00

09:00 < 09:15

09:15 < 09:30

09:30 < 09:45

09:45 < 10:00

10:00 < 10:15

10:15 < 10:30

10:30 < 10:45

10:45 < 11:00

11:00 < 11:15

11:15 < 11:30

11:30 < 11:45

Room1

Room2

Room3

Re: Show if timeslots are 'occupied' from time range

c_gilbert — Fri, 12 Apr 2019 13:18:52 GMT

Can anyone help?