Room Empty or Occupied

[#1]

HI

I have a table with roomno, start and end time so I can see when a room is occupied

I have also created a timeline for a whole day.  (See attached example)

Now I want to make a table to seee when a room is occupied and when a room is empty

in this table it should be green then or is emoty, it should be red then, but it if the outcome of the expression is 1 whne the room is occupied and 0 when it is

emoty.

Does anyone have an idea how to solve this???

[hic]

You should look at Intervalmatch. With this prefix you can create a map between individual points in time and intervals.

You should also look at different types of Gantt charts to visualize this. http://community.qlik.com/docs/DOC-3113

HIC

[#3]

Gants charts looking  prommissing 

Thanks