Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);
Hi try this expression
Time(Subfield(Time,'-',2) )as Time