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)



        • Re: Convert Time Period to Time
          Sunny Talwar

          May be like this



          LOAD [Network Date],


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

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




              [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)]



          (ooxml, embedded labels, table is Sheet1);


          • Re: Convert Time Period to Time
            Hemachandran Deyvasigamani

            Hi try this expression


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