Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Time (in field)

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

3 Replies
Highlighted
Master II
Master II

Re: Time (in field)

Maybe something like:

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

Highlighted
Contributor
Contributor

Re: Time (in field)

Thanks! Working fine.

How can I now group time into 60 minutes intervalls?

Highlighted
Master II
Master II

Re: Time (in field)

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