Convert Time Period to Time

[akpofureenughwu]

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

[sunny_talwar · Accepted solution]

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);

[hemachandran]

Hi try this expression

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