3 Replies Latest reply: Sep 27, 2017 7:34 AM by Bill Markham RSS

    Change number to time

    P K

      Hello everyone,

       

      I have question about Qlik Sense and conversion number (probably int) to time.

      Our system ERP shows time as number (for example 742, 1840, 2130 where it is 7:42, 18:40, 21:30).

      Unfortunately there is no dependence here because time 00:00 shows as 0 and 00:25 shows as 25.

      I would like to write it more readable for report users in the form of time not number.

       

      Can qlik allow such atypical conversions? Is there anyone who will help to the new user ?

       

      BR,
      Patryk