Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikers,
Here is my challenge:
12:40:59 to be 12:41:00
12:40:01 to be 12:40:00
In to time to the nearest minute, How can I do this using the the script;
Thank you
Try like:
Time(Round(Time#(<yourTime>, 'hh:mm:ss'), 1/24/60)) as NearestMinute
Hi
above tresesco solution is working as you expected.
Format:
LOAD * INLINE [
Duration
12:40:50
12:40:05
];
Result:
LOAD *,
Time(Round(Time#(Duration, 'hh:mm:ss'), 1/24/60)) as NearestMinute
Resident Format;
exit SCRIPT;
Thank you So much it works,
But one more question is this work on the below ?
12:40:50 to be 12:41:00
12:40:05 to be 12:40:00
Thank you
Hi
above tresesco solution is working as you expected.
Format:
LOAD * INLINE [
Duration
12:40:50
12:40:05
];
Result:
LOAD *,
Time(Round(Time#(Duration, 'hh:mm:ss'), 1/24/60)) as NearestMinute
Resident Format;
exit SCRIPT;