topic Adding custom strings to formats (interval, date, time) in QlikView

Adding custom strings to formats (interval, date, time)

pauluk__ — Tue, 24 Jan 2017 11:05:21 GMT

Hi,

I'm using the interval function to work out the period between two datetime values, in days and hours, as below:

Interval(ReloadTime() - L_DispatchRequestTime, 'd - hh')

Whilst this gives the correct results it looks very confusing. I'm looking to add my own custom labelling to the format so I can something like:

'1 day 5 hours'

Is there any way of adjusting the formatting so I can fully customise the labelling, or get the result above?

Thanks in advance.

marcus_sommer — Tue, 24 Jan 2017 11:16:26 GMT

Try something like this: =replace(replace(interval(1.55, 'd X - h Z'), 'X', 'day(s)'), 'Z', 'hours')

- Marcus

pauluk__ — Tue, 24 Jan 2017 13:41:44 GMT

This works great, thanks.