topic Re: Interval Formatting incl. Description in QlikView

Interval Formatting incl. Description

Tue, 04 Aug 2015 08:48:21 GMT

Hi,

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?

Greetings

Gysbert_Wassenaar — Tue, 04 Aug 2015 08:55:27 GMT

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

Tue, 04 Aug 2015 09:11:30 GMT

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