4 Replies Latest reply: Apr 10, 2018 12:24 AM by Pandiarajan Radhakrishnan 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