Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
c_gilbert
Creator II
Creator II

Show if timeslots are 'occupied' from time range

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. 

RecordIDRoomMeetingDateMeetingStartMeetingEnd
1Room101/04/201907:0007:30
2Room101/04/201908:0010:00
3Room201/04/201909:0011:00
4Room301/04/201909:3010:30

 

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

 07:00 < 07:1507:15 < 07:3007:30 < 07:4507:45 < 08:0008:00 < 08:1508:15 < 08:3008:30 < 08:4508:45 < 09:0009:00 < 09:1509:15 < 09:3009:30 < 09:4509:45 < 10:0010:00 < 10:1510:15 < 10:3010:30 < 10:4510:45 < 11:0011:00 < 11:1511:15 < 11:3011:30 < 11:45
Room1XX    XXXXXX       
Room2        XXXXXXXX   
Room3          XXXX     
1 Reply
c_gilbert
Creator II
Creator II
Author

Can anyone help?