Discussion board where members can get started with QlikView.
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.
DATE TYPE AMOUNT DESCRIPTION
01/01/2018 CR 100 CRN: 013141345, RRN: 04641508 B/O: SFER NAME/ ADRESS POST 03:00
Maybe something like:
=if(IsNum(right(DESCRIPTION,5)),right(DESCRIPTION,5),'00:00') as MyTime
Thanks! Working fine.
How can I now group time into 60 minutes intervalls?
=floor(frac(STARTTIME)*24)/24+floor(STARTTIME) as LowestHour