3 Replies Latest reply: Oct 6, 2014 10:20 AM by pablo masotta RSS

    date and time functions help ....

    selva elango

      I have this data loaded to Qlikview.

       

       

      datetimecodestatusorder num
      7/31/201311:50:00Impstart12345
      7/31/201313:00:00impend12345
      7/31/201315:24:00impstart12334
      7/31/201316:49:00impend12334

       

       

      I have the above table , now i need to calculate the average process time of the order in the date. need to display the time taken to process one order when the order is selected.

       

      Can someone help with this.