Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
giancarlo_satur
Contributor II
Contributor II

How to convert (thousand of) minutes in day, hour..

Hello everybody, I have this field formatted in minutes and I would like to convert it in day, hours and minutes. Ad exemple TIME=36000 minutes I would like see it like this 2 dd 12 hh 00 mm

How to?

Very thanks

1 Solution

Accepted Solutions
adamdavi3s
Master
Master

load TIME, interval((TIME/60/24),'d.hh:mm');

LOAD * INLINE [

TIME

36000

1440

];

View solution in original post

3 Replies
adamdavi3s
Master
Master

load TIME, interval((TIME/60/24),'d.hh:mm');

LOAD * INLINE [

TIME

36000

1440

];

giancarlo_satur
Contributor II
Contributor II
Author

great! very thanks!

adamdavi3s
Master
Master

No problem at all