Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Covert hh:mm:ss to Days hh:mm:ss

Hi,

I have a field called Fix_date_true, which currently pulls out a time format such as 73:01:24 (hh:mm:ss).  However I want to be able to convert this date into Days hh:mm:ss, so the above will show : 2 01:01:24 (This will shows 2 Days 01 Hour 01 Minutes and 24 Seconds).  Is this possible in an Expression.

Regards,

Jon Ditchfield

1 Solution

Accepted Solutions

Re: Covert hh:mm:ss to Days hh:mm:ss

interval(Fix_date_true, 'D hh:mm:ss') or perhaps interval(interval#(Fix_date_true, 'hh:mm:ss'), 'D hh:mm:ss'). Depends on what data type Fix_date_true has.


talk is cheap, supply exceeds demand
1 Reply

Re: Covert hh:mm:ss to Days hh:mm:ss

interval(Fix_date_true, 'D hh:mm:ss') or perhaps interval(interval#(Fix_date_true, 'hh:mm:ss'), 'D hh:mm:ss'). Depends on what data type Fix_date_true has.


talk is cheap, supply exceeds demand
Community Browser