topic Re: Time format with days in QlikView

Time format with days

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I'm trying to show the spent time in several tasks in a graph but I can't get the format that I need.

I want to show the numbers with days, hours and minutes, but when the time is more than a day, only I can show the hours and minutes.

Thanks a lot

Re: Time format with days

Colin-Albert — Thu, 10 Aug 2017 15:12:17 GMT

What defines a day for your problem?

Is a day 24 hours, or a working day of say 8 hours.

Can you provide some examples of the start and end data showing the expected output?

Re: Time format with days

Anonymous — Thu, 10 Aug 2017 15:36:13 GMT

Hi Colin,

Is a day of 24 hour

Re: Time format with days

jmvilaplanap — Thu, 10 Aug 2017 15:38:13 GMT

Hi,

You can try with:

if(floor(sum(Time)) > 0, num(floor(sum(Time)), '#,### days' )) & ' ' & Time(sum(Time), 'hh:mm')

With this, you could see: x days 22:33

Re: Time format with days

Anonymous — Thu, 10 Aug 2017 15:40:20 GMT

Hi Jose,

This solution works, but I can't use it in chart objects, only in texts,

There is no way to do something like time(mytime, 'dd Days, hh:mm');

Regards

Re: Time format with days

chris_johnson — Thu, 10 Aug 2017 16:11:27 GMT

Hi,

You could try looking at the interval() function, I think this might help get what you want (although I've not tried it myself):

Interval ‒ QlikView

The examples seem to suggest you can separate days out

Re: Time format with days

Anonymous — Fri, 11 Aug 2017 08:37:47 GMT

Hi Adam,

This almost works, but is not possible to write the word "Days" inside the format. Because D is like a day(numeric), y as year and s as second.

There are not escape characters?

Thanks

Re: Time format with days

antoniotiman — Fri, 11 Aug 2017 08:51:41 GMT

Hi Maikel,

to get 'Days' in Text try like yhis

Replace(Date(date,'DD/MM/YYYY'&' @'),'@','Days')

Regards,

Antonio

Re: Time format with days

Anonymous — Fri, 11 Aug 2017 09:34:01 GMT

Great workaround Antonio!