0 Replies Latest reply: Sep 25, 2018 4:05 AM by Florian Käfert RSS

    Group Data to get a Filling Level over Time

    Florian Käfert

      Hi Qlik-Community,

       

      I have a table (GanntTable) that contains an ID, a Type and EntryTimestamp, ExitTimestamp. I use this table to display a Gannt Chart.

       

      GanntTable:

      IDTypeEntryTimestampExitTimestamp
      AArea101/01/2018 10:00:0001/01/2018 15:00:00
      AArea201/01/2018 15:00:0001/01/2018 20:00:00
      BArea101/01/2018 13:00:0001/01/2018 18:00:00
      ............

       

      In a second table (IDOverview) the size for the each ID is listed.

      IDOverview:

      IDSize
      A5
      B10
      C8
      ......

       

      It is possible to build a chart, that shows in 10 minute steps the filling level of a specific Type?

       

      Thanks

      Flow