5 Replies Latest reply: Nov 22, 2017 11:17 AM by JORDI TORRAS RSS

    KPI Calculation


      Dear Gurús,


      I have a table as follows:


      Date_TimeRolling Time
      22/11/2017 11:55:1525
      22/11/2017 11:56:2330
      22/11/2017 11:57:1640
      22/11/2017 11:58:3110
      22/11/2017 11:59:2615



      And I have to make a calculation as follows:


      ( (Date_Time) - (Previous Date_Time) ) * Rolling Time


      I've found a way for this calculation but in some cases some record is not picking the correct Previuos Date_Time.


      Can anyone suggest a way for this calculation? This can be done in the script or in QlikSense Application.


      Thanks in advance!!