Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
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?

1 Solution

Accepted Solutions
MarcoWedel

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
galax_allu
Specialist
Specialist

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


MindaugasBacius
Partner
Partner

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

Not applicable
Author

It is in hh:mm:ss now..

rwunderlich

I suggest:

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

MarcoWedel

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