5 Replies Latest reply: Nov 22, 2017 11:17 AM by Jordi Torras Carreño RSS

    KPI Calculation

    Jordi Torras Carreño

      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!!

       

      Regards,

      Jordi