Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Highlighted
Creator III
Creator III

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)

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.

Highlighted
Creator III
Creator III

Thanks for your help.