Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Interval Formatting incl. Description


i have a formula with an interval statement which got a formatting 'dd:hh:mm'. Everything works fine. But i need a description of Days in my chart.

At the moment, for example my chart looks like '22:20:03' but now i want to have it like this way '22 Days 20 hours 03 Minutes'.

Is that possible?


2 Replies

Re: Interval Formatting incl. Description

Floor(MyInterval) & ' Days' &  Hour(MyInterval) & ' Hours' & Minute(MyInterval) & ' Minutes'

talk is cheap, supply exceeds demand
Not applicable

Re: Interval Formatting incl. Description

When I write ' Days' behind the first part of the formula, in my chart there are no values. But for example '%' works...

Community Browser