Trying to create a first case start time (hospital dashboard)

[#1]

Hi all,

I'm trying to figure out how to get this working.. i've very very slowly been converting my hospitals crystal reports over to qlikview where possible (where its possible for ME to do it ) and I thought this one would be rather easy, but I'm finding out it is not.

What I have is as follows:

room_mnc (Room Name)

book_start_time (the time we want to start, booked months ahead of time) (text equivalent of time.. ie 824=8:24am in military time)

actual_start_time (the time we actually started that day) (text equivalent of time.. ie  824=8:24am, in military time)

time_pt_in_room (the time the patient entered the room, diff than above time) (timestamp  xx:xx in military time)

cr_prdate  (date) (datetime field xx/xx/xxxx xx:xx:xx AMPM)

All of the data will be refreshed on a 30min interval (this is for operating rooms that keep swinging patients in/out etc) and what I need to do is pull each room as a list and tag on to them the earliest time_pt_in_room and ignore the rest (the earliest can be at 12:01am if it happens that way) and then just tag on the other fields, but I'd also like all the time formats to just be as normal timestamps of xx:xx in military time.

What I'd also like todo is also have it select a specific set of rooms, not only import them in the script.. I need ALL the rooms, but this form needs to display only rooms from .CH0R001 through .CH0R021 and also another 1 or 2 not named the same.

Any help would be appreciated.. like i said I was converting this from Crystal reports, which worked just fine and I got this working in there pretty easily.. just really really horrible at the ETL side of qlikview and still learning the expressions etc that are built in.

I thought that maybe if I tried to save the input as a qvd and then re-call up the qvd for just minimum times per or room it would work, but it keeps failing..

my script is attached..

Thanks  Stan