This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I need to calculate the Date & time difference in hours excluding the weekends. i have a below expression, which provides time difference in hours. But i need to exclude the weekends as well in this.
interval(timestamp2 - timestamp1,'hh')
looking for any suggestion.
considering 2 variables:
v1 = 2020-08-21 20:00:00 (older timestamp)
v2 = 2020-08-24 21:00:00 (newer timestamp)
This expression will use the NetWorkDays function to get the working days (excluding weekends), and the second part will calculate the difference on the time part:
=interval((NetWorkDays('$(v1)', '$(v2)') - 1) + (frac('$(v2)') - frac('$(v1)')),'hh')
Hi Fosuzuki,I think your solution works when v2 is greater than v1 variable. But in my case, some times, v1 is greater than v2.
Deepak K M