Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What format is this? 00:01:49:7
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
];