9 Replies Latest reply: Nov 8, 2017 3:11 AM by alessandro trinca RSS

    Qlik Sense Script: how to evaluate if a Timestamp interval is less than "n" seconds

    alessandro trinca

      Hello to all,

      can anyone help me in this?

       

      I've to evaluate if a Timestamp interval is less than 5 seconds (for example) between 2 records, using Qlik Sense Script.

       

      How can I do this better?

       

      I've tried with this statement:

       

          if(interval((TimeString - (Previous(TimeString))), 'hh:mm:ss') < time('hh:mm:ss','00:00:05'), 'alert','')

          as FlagAlert_5sec

       

      This is the Timestamp Format:  "04.11.2017 00:15:00" (TimeString)

       

      Thank you for your help!