10 Replies Latest reply: Nov 28, 2017 9:29 AM by Christoph Hebig RSS

    Qlik Sense omitting Milliseconds

    Christoph Hebig

      Hi Community,

       

      I have a requirement for my current app to load the milliseconds of a time field, but for some reason qlik is omitting the milliseconds value. I've tried editing the variables in the Main tab in the loading script and also tried some shenanigans with the num#/timestamp# and time-functions.

       

      Here's also an example of the database

       

      Experiment NumberMachineDwell TimeWaiting Time
      1100:01:02.527000:00:02.8145
      1100:00:56.635400:00:02.4587
      1100:00:42.458400:00:04.8537
      1200:01:02.557400:00:03.6584

       

      Usually i would ignore the milliseconds, but i have around 50 rows per machine, each nearly 1 second in milliseconds, which means i got a total difference of around 40 to 50 seconds.

       

      Thanks in advance

      Chris