topic Re: interval result formatting in QlikView

interval result formatting

Mon, 26 Oct 2015 10:41:01 GMT

Hello,

I would like formating the result of durationminutes like a number #.### but I don´t know How can I do it?

I need to show IncidenceDurationMin with thousand point

Schedule:

LOAD :

Incidencetart,

Incidenceend,

time(datetime_start-datetime_end,'hh:mm:ss') as IncidenceDuration,

interval(datetime_start-datetime_end,'mm') as IncidenceDurationMin

FROM [SCHEDULETIME.XLS];

Gysbert_Wassenaar — Mon, 26 Oct 2015 17:53:54 GMT

Try: num(floor(datetime_start-datetime_end*60*24),'#.##0') as IncidenceDurationMin

swuehl — Mon, 26 Oct 2015 18:02:16 GMT

Ana, please be patient if you don't receive answers immediately and try to avoid multiple postings about the same request:

P.S: I guess there should be brackets around the difference calculation in Gybert's expression and probably an end-start calculation

num(floor( (datetime_end-datetime_start) *60*24),'#.##0,',',','.') as IncidenceDurationMin

Gysbert_Wassenaar — Mon, 26 Oct 2015 18:06:56 GMT

Good point. I missed that there were two fields.

MarcoWedel — Mon, 26 Oct 2015 23:44:25 GMT

Hi,

see your other thread

hope this helps

regards

Marco