topic Re: Dates Diff in QlikView

Dates Diff

master_student — Fri, 27 Oct 2017 13:55:27 GMT

hello Guys,

I hope all is well.

I need to get the difference between two date fields in hours: minutes that have this format : 'DD/MM/YYYY hh:mm:ss' without counting saturday and sundays. My actual expression :

(NetWorkDays([ROW_ADDED_DTTM], [ROW_LASTMANT_DTTM]))

gives this result :

I need the result in hours knowing that the working hours are from 8h=>18h

so the result would be : 8H44 =>18h + 8h=>10:04

Any idea pleaase

Thanks in advance

Re: Dates Diff

sunny_talwar — Fri, 27 Oct 2017 15:05:30 GMT

May be check this

Business Working Hours Calculation

Re: Dates Diff

master_student — Mon, 30 Oct 2017 10:12:52 GMT

Hello Sunny,

Thanks for the link, i used the first script

1) Calculate business working hours excluding week ends(Saturday and Sunday) and Holidays.

but the result seems wrong. attached is my script (in the first conversation)

Re: Dates Diff

sunny_talwar — Mon, 30 Oct 2017 11:10:33 GMT

Let's see if kush141087‌ is available to help as he is the one who created the blog. He might be able to resolve this much better then I can.

Re: Dates Diff

master_student — Mon, 30 Oct 2017 11:12:10 GMT

Thanks for your help.