topic Re: Format an interval result as ###.### in QlikView

Format an interval result as ###.###

Mon, 26 Oct 2015 09:35:36 GMT

Hello,

I need to do a pivot table with the following information.

I have problems to represent the field DurationMinutes like a number with format ###.###

SCHEDULE:

LOAD

ScheduleDate,

START_TIME as ScheduleStart,

END_TIME as ScheduleEnd,

time(DELAY_END_TIME - DELAY_START_TIME,'hh:mm:ss') as Duration,

interval(DELAY_END_TIME - DELAY_START_TIME,'mm') as DurationMinutes

FROM [..\Timing.xls];

I can´t represent the field DurationMinutes like a number.

Re: Format an interval result as ###.###

sunny_talwar — Mon, 26 Oct 2015 15:44:41 GMT

May be this:

SCHEDULE:

LOAD

ScheduleDate,

START_TIME as ScheduleStart,

END_TIME as ScheduleEnd,

time(DELAY_END_TIME - DELAY_START_TIME,'hh:mm:ss') as Duration,

Num(DELAY_END_TIME - DELAY_START_TIME,'###.###') as DurationMinutes

FROM [..\Timing.xls];

Re: Format an interval result as ###.###

Mon, 26 Oct 2015 16:37:50 GMT

It doesn´t work the result have to be like the filed IncidenceDurationMin with millar point

7.203

Re: Format an interval result as ###.###

yura_ratu — Mon, 26 Oct 2015 17:12:32 GMT

Hi Ana,

Try this one

num((DELAY_END_TIME-DELAY_START_TIME)*1440,'#,##0.') as DurationMinutes

Re: Format an interval result as ###.###

Anonymous — Mon, 26 Oct 2015 18:52:55 GMT

Try it.

NUM(Interval(DELAY_END_TIME - DELAY_START_TIME,'MM'),'###.###') as DurationMinutes

Regards.

Re: Format an interval result as ###.###

Mon, 26 Oct 2015 19:13:55 GMT

Hi Ana! Try this:

SCHEDULE:

LOAD

ScheduleDate,

START_TIME as ScheduleStart,

END_TIME as ScheduleEnd,

time(DELAY_END_TIME - DELAY_START_TIME,'hh:mm:ss') as Duration,

num(interval(DELAY_END_TIME - DELAY_START_TIME,'mm'), '###.###') as DurationMinutes

FROM [..\Timing.xls];

I hope that it help you !

Re: Format an interval result as ###.###

MarcoWedel — Mon, 26 Oct 2015 23:42:15 GMT

Hi,

some solutions could be also:

Num(Num#(Interval(IncidenceEnd-IncidenceStart,'mm')),'#.###') as IncidenceDurationMin         
Num((IncidenceEnd-IncidenceStart)/'00:01:00','#.##0') as IncidenceDurationMin

rounding minutes off:

Num(Floor((IncidenceEnd-IncidenceStart)/'00:01:00'),'#.##0') as IncidenceDurationMin
Num(Div(IncidenceEnd-IncidenceStart,'00:01:00'),'#.##0') as IncidenceDurationMin

hope this helps

regards

Marco

Re: Format an interval result as ###.###

lenka_kruse — Tue, 08 Mar 2016 16:41:29 GMT

Thank you so much, this just saved my day!