Interval pattern

Tue, 29 Mar 2011 10:54:23 GMT

Hi,

I have a field containing a time interval between two dates.

I want to format this number with format : 4d, 3h

If I set "Interval" on Number tab with number pattern like "d d, h h" it replace every d or h char with the result, showing "4 4 3 3".

Is there any escape char on format string that I can use?

I've tried some like \d or 'd' unsuccessfully.

Thankyou!

Interval pattern

Miguel_Angel_Baeyens — Tue, 29 Mar 2011 11:32:52 GMT

Hello,

There's no way to get the format that way, so you will need to play with string functions to manually add the "d" or "h" characters to the result. As an example try this:

=SubField(Interval('25:00','D:h'), ':', 1) & 'd ' & SubField(Interval('25:00','D:h'), ':', 2) & 'h'

Hope that helps.

topic Interval pattern in QlikView

Interval pattern

Interval pattern