Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

convert millisecond into hh:mm:ss in qlikview

Hello All,

Is it possible to convert milliseconds into hh:mm:ss in qlikview.

Many thanks for your help.

Kind Regards,

Hasvine

1 Solution

Accepted Solutions
manojkulkarni
Partner - Specialist II
Partner - Specialist II

try this

interval(round(milliseconds/1000)/(60*60*24),'hh:mm:ss')

View solution in original post

4 Replies
manojkulkarni
Partner - Specialist II
Partner - Specialist II

try this

interval(round(milliseconds/1000)/(60*60*24),'hh:mm:ss')

MK_QSL
MVP
MVP

=Interval(Interval#(YourMSField/1000,'ss'),'hh:mm:ss')

Not applicable
Author

Hi All,

Thanks you for the quick response.

Your answer is correct.

Thanks you.

KR,

Hasvine

sasikanth
Master
Master

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