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.
| RecordID | Room | MeetingDate | MeetingStart | MeetingEnd |
| 1 | Room1 | 01/04/2019 | 07:00 | 07:30 |
| 2 | Room1 | 01/04/2019 | 08:00 | 10:00 |
| 3 | Room2 | 01/04/2019 | 09:00 | 11:00 |
| 4 | Room3 | 01/04/2019 | 09:30 | 10:30 |
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 | X | X | | | | | X | X | X | X | X | X | | | | | | | |
| Room2 | | | | | | | | | X | X | X | X | X | X | X | X | | | |
| Room3 | | | | | | | | | | | X | X | X | X | | | | | |
