Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Convert duration to minutes

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?

Tags (3)
1 Solution

Accepted Solutions
Highlighted

Re: Convert duration to minutes

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

View solution in original post

5 Replies
Highlighted
Valued Contributor

Re: Convert duration to minutes

Hi


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

or


please post a sample data or scree shot


Highlighted
Valued Contributor III

Re: Convert duration to minutes

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

Highlighted
Not applicable

Re: Convert duration to minutes

It is in hh:mm:ss now..

Highlighted
MVP & Luminary
MVP & Luminary

Re: Convert duration to minutes

I suggest:

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Highlighted

Re: Convert duration to minutes

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

View solution in original post