Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-10-27 09:11 AM

Interval in DD HH:MM just excluding 'Sunday'

Greetings all,

I have a small issue, I want to calculate the interval between 2 dates but excluding the Sunday, not all the weekend. So far I had been using the 'NetWorkDay()' function but this one is excluding Sunday and Saturday too. Saturday I want it in the calculation.

So the result that I want should be in Days Hours:Minutes (interval)

Anyone has any idea how I can do this ?

Thank you!

1,795 Views
0 Likes
11 Replies
swuehl
MVP
MVP
‎2015-10-27 10:48 AM

In response to

What do you mean with not working properly?

Please note that I just made a change before your post to the expression.

If this is not working for you, please provide the timestamps that result in incorrect interval. And the expected interval.

152 Views
0 Likes
Not applicable
‎2015-10-27 11:02 AM
Author

In response to swuehl

I did some tests, and everything is ok. Thank you very much ! Very very helpful.

152 Views
0 Likes