Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Is it possible to convert milliseconds into hh:mm:ss in qlikview.
Many thanks for your help.
Kind Regards,
Hasvine
try this
interval(round(milliseconds/1000)/(60*60*24),'hh:mm:ss')
=Interval(Interval#(YourMSField/1000,'ss'),'hh:mm:ss')
Hi All,
Thanks you for the quick response.
Your answer is correct.
Thanks you.
KR,
Hasvine
Hi,
Try some thing like
TimeStamp(MakeDate(1970) + (timestamp / (1000 * 60 * 60 *24)), 'MM/DD/YYYY hh:mm:ss.fff') as New_Date,
to get hours take only hour format