topic Re: format hh:mm:ss in QlikView

format hh:mm:ss

MauriceLudo — Wed, 10 Jan 2018 10:10:16 GMT

Hi,

00:01:49:7 excel rounded 00:01:50 while qlikview the rounded 00:01:49 how i can arroundi with qlikview in 00:01:50

Thank you

Best regards

Maurice

Re: format hh:mm:ss

Anil_Babu_Samineni — Wed, 10 Jan 2018 11:32:31 GMT

What format is this? 00:01:49:7

Re: format hh:mm:ss

zhadrakas — Wed, 10 Jan 2018 11:45:13 GMT

hello Maurice,

i dont understand this Format too.

here is a script where i manually round up or down. This code works but there should be a better way to do it.

Load
if(right(TIME,1)<6,
time(date#(left(TIME, 😎 , 'hh:mm:ss'), 'hh:mm:ss'),
time(MakeTime(hour(left(TIME, 8)), minute(left(TIME, 8)), Second(left(TIME, 8))+1 ), 'hh:mm:ss')) as TIME
;
LOAD * INLINE [
TIME
00:01:49:7
];