topic Re: Convert duration to minutes in QlikView

Convert duration to minutes

Wed, 25 Nov 2020 16:16:04 GMT

I have a measure "Total Causal Time" and it is displayed in duration format, is there a way to convert this to straight cumulative minutes?

Re: Convert duration to minutes

Anonymous — Thu, 07 Jul 2016 15:23:19 GMT

please let me know 'Total Causal Time' is in seconds or hours or days ?

if it is in seconds

Total Causal Time'/60 will give you minutes

Total Causal Time'/(60*60) will give you hours

please post a sample data or scree shot

Re: Convert duration to minutes

MindaugasBacius — Thu, 07 Jul 2016 15:26:10 GMT

I am not 100% sure if this is your case. It sounds like that

For minutes:

time([Total Causal Time] / 1440) as Time

For seconds:

time([Total Causal Time] / 86400) as Time

Re: Convert duration to minutes

Thu, 07 Jul 2016 15:26:25 GMT

It is in hh:mm:ss now..

Re: Convert duration to minutes

rwunderlich — Thu, 07 Jul 2016 16:03:41 GMT

I suggest:

Interval( Interval#([Total Casual Time], 'hh:mm:ss'), 'm')

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Convert duration to minutes

MarcoWedel — Thu, 07 Jul 2016 22:45:55 GMT

Hi,

maybe by changing the Format Pattern in the Number tab of your chart properties to "m" or by multiplying your measure with 1440 and format as Integer (number 1 representing 1 day, 24h or 24*60=1440 minutes):

[Total Causal Time] * 1440

hope this helps

regards

Marco