Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andrewmo
Creator
Creator

Summing with intervalmatch

Hello

I am trying to build a display that shows the utilization of each surgical block in an operating room.

To do so I have to create three main tables:

A case details table that has the case times and locations

A master calendar table

A block calendar table that contains possible dates for each block based on the day of the week and week number of the month.

I then need to use a combination of all the above tables to be able to see the count of cases going at any minute of a given day versus the amount of rooms available for that specific block at that specific time.

I would like to see something similar to this:

MINOFDAY.png

The issue I have as seen in the pic above is I am not able to capture distinct minute of day (notice 8:21 and 8:28) nor am I able to figure out the logic to capture the number of cases going at that time of day.

I have attached a few dummy cases to my logic in the QVW below.

Please let me know if you have any suggestions.

Thanks again

11 Replies
andrewmo
Creator
Creator
Author

Perfect, thanks again Sunny!

andrewmo
Creator
Creator
Author

Hi Adam

Sunny gave me a great framework to work with, however I would still like to see what you have built.

Thanks again