Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Time Tracking of Meetings

Hi

Not really sure where to start with this challenge.

I am trying to track occupancy levels of meeting rooms in a Community Centre.

I have data which has a start time and end time - all meetings are same day i.e. none span midnight. I need to show the utilization of a meeting room i.e.

Meeting Room           Start Time          End Time

Room 1                    9:00                    11:00

Room 1                    13:00                   15:00  

I would like to see a chart hour by hour of a day that shows in the above example between the hours of 11:00 and 13:00 it was empty.

Additionally some meetings may be on the half hour ? If that makes a difference to the challenge.

As I say I not sure where to start with this one so would appreciate any support that be offered,

Many thanks,


Rob

1 Reply
MVP
MVP

Re: Time Tracking of Meetings

Rob,

there are probably multiple approaches, maybe you want to take a look at this one:

http://community.qlik.com/thread/48787

Community Browser