7 Replies Latest reply: Mar 24, 2017 5:46 PM by GE US Enterprise Solutions RSS

    QlikView Script - activity between timestamps

    marcin szuberla

      Hi,

       

      I would like to ask the experts here, what would the best approach be to solve this:

       

      I have a file with about half a million records. Each task (record in the file) has two timestamps (task start, task end).

      I would like to be able to tell, at any point in time, whether there was any activity (tasks in progress), how many unique tasks were in progress, total idle time (no tasks in progress), etc.

       

      If you can point me to some reading material on how to do this, I will be very thankful!

       

      Marcin