Discussion Board for collaboration on QlikView Scripting.
I have a column with data only in seconds for e.g. 5402sThis I want to split it as 01:30:02 i.e 1 Hour 30 Minutes 2 Seconds.
Thanks in advance!
Go to Solution.
Try like this
=interval(timestamp#(5402, 's'), 'hh:mm:ss')