Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
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?