topic Time (in field) in QlikView

Time (in field)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am new at Qlikview...

I have excel files where the time is included in a specific field called "DESCRIPTION", where the last 5 digits in that field are time specific and to be considered, i.e. "03:00".

However some rows do not include a time (but other information) and should therefor not be considered, or at least considered as "00:00".

How can I read out the time stamp from the "DESCRIPTION" field.

Example.....

DATE TYPE AMOUNT DESCRIPTION

01/01/2018 CR 100 CRN: 013141345, RRN: 04641508 B/O: SFER NAME/ ADRESS POST 03:00

Re: Time (in field)

m_woolf — Tue, 16 Jan 2018 20:05:56 GMT

Maybe something like:

=if(IsNum(right(DESCRIPTION,5)),right(DESCRIPTION,5),'00:00') as MyTime

Re: Time (in field)

Anonymous — Thu, 18 Jan 2018 08:06:22 GMT

Thanks! Working fine.

How can I now group time into 60 minutes intervalls?

Re: Time (in field)

m_woolf — Thu, 18 Jan 2018 12:27:58 GMT

=floor(frac(STARTTIME)*24)/24+floor(STARTTIME) as LowestHour