2 Replies Latest reply: Mar 8, 2017 8:22 AM by Hemachandran Deyvasigamani RSS

    Convert Time Period to Time

    Akpofure Enughwure

      Good day everyone,

       

      I have a data set, that have a time period from 12:00am -1:00am and so on, I would love to convert that period to a specific time say 12:00am- 1:00 am to just 1:00am..

      Attached is a sample data file. and I would love to replicate what I saw on the community some time ago on qliksense with the sample data. (see attached)

       

      Regards

        • Re: Convert Time Period to Time
          Sunny Talwar

          May be like this

           

          Table:

          LOAD [Network Date],

              Time,

              Hour(Trim(SubField(Time, ' - ', 2))) as Hour,

              Time(Trim(SubField(Time, ' - ', 2))) as NewTime,

              Downtime,

              Uptime,

              Coverage,

              [Traffic Total (volume in KByte)],

              [Traffic Total (speed in kbit/s)],

              [Traffic In (volume in KByte)],

              [Traffic In (speed in kbit/s)],

              [Traffic Out (volume in KByte)],

              [Traffic Out (speed in kbit/s)],

              [Errors in (volume in #)],

              [Errors in (speed in #/s)],

              [Errors out (volume in #)],

              [Errors out (speed in #/s)],

              [Discards in (volume in #)],

              [Discards out (volume in #)],

              [Discards out (speed in #/s)]

          FROM

          [..\..\Downloads\Sample.xlsx]

          (ooxml, embedded labels, table is Sheet1);


          Capture.PNG

          • Re: Convert Time Period to Time
            Hemachandran Deyvasigamani

            Hi try this expression

             

            Time(Subfield(Time,'-',2) )as Time