topic Re: NetworkDays Expression in QlikView

NetworkDays Expression

Wed, 09 Apr 2014 13:21:14 GMT

Hello,

I am looking to do an expression similar to a networkdays one, however I do not want the days I want to show the number of hours.

My dates are set up as follows:

ACTIVITY_DATE = DD/MON/YYYY hh:mm

ACTIVITY_END = DD/MON/YYYY hh:mm

So when using the normal networkdays expressions (=NETWORKDAYS(ACTIVITY_DATE,ACTIVITY_END)) I received 0 as the activity has happened on the same day. Is there a way of calculating the hours?

Thank you.

Re: NetworkDays Expression

MK_QSL — Wed, 09 Apr 2014 13:31:00 GMT

=TIME(ACTIVITY_END , ACTIVITY_DATE, 'hh:mm:ss')

Re: NetworkDays Expression

Wed, 09 Apr 2014 14:10:43 GMT

Does't seem to like the , before 'hh:mm:ss' and comes up with an error.

Re: NetworkDays Expression

MK_QSL — Wed, 09 Apr 2014 14:18:02 GMT

Try this...

=TIME(Timestamp#(ACTIVITY_END,'DD/MMM/YYYY hh:mm') - Timestamp#(ACTIVITY_DATE,'DD/MMM/YYYY hh:mm'),'hh:mm')

Re: NetworkDays Expression

Wed, 09 Apr 2014 14:21:23 GMT

Hi,

You can try

=NetWorkDays(ACTIVITY_DATE, ACTIVITY_END) + Frac(Time(ACTIVITY_END-ACTIVITY_DATE, 'hh:mm'))

Re: NetworkDays Expression

Wed, 09 Apr 2014 14:58:14 GMT

Use Interval() function.

Interval(ACTIVITY_END-ACTIVITY_DATE, 'D hh:mm')