7 Replies Latest reply: Oct 7, 2013 4:03 PM by Michael Solomovich RSS

    First time of day by room

      Hi,

       

      Lets say i have the following data:

       

      DayRoomPatientRegisteredAppStartAppEnd
      AppID
      8/1/2013A07:0707:1507:451
      8/1/2013A07:5107:5508:102
      8/1/2013B07:1507:2007:253
      8/1/2013B07:3007:3507:454
      8/2/2013A08:0508:1008:405
      8/2/2013A07:3007:3507:506
      8/2/2013B08:1508:3008:407
      8/2/2013B08:4008:5009:108

       

      I want to create a line graph that shows by day the first times of the day by room. Purpose is to monitor if appointments and registration started on time.

       

      I did see that it is possible to load the data again grouped by the day and room, but was wondering is it is possible in the Qlikview document also.

       

      Any help would be appreciated.

      Robbert