Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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


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

4 Replies

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.

Creator III
Creator III

Thanks for your help.