Announcements
cancel
Showing results for
Did you mean:
Creator III

Convert Time Period to Time

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

1 Solution

Accepted Solutions
MVP

May be like this

Table:

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

FROM

(ooxml, embedded labels, table is Sheet1);

2 Replies
MVP

May be like this

Table:

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

FROM