Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

Dates Diff

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 :


Capture.PNG


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

4 Replies
sunny_talwar

master_student
Creator III
Creator III
Author

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)

sunny_talwar

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.

master_student
Creator III
Creator III
Author

Thanks for your help.