Discussion Board for collaboration related to QlikView App Development.
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.
Try something like this: =replace(replace(interval(1.55, 'd X - h Z'), 'X', 'day(s)'), 'Z', 'hours')
This works great, thanks.