Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Interval between timestamp with no holiday

Hi,

I have log_from and Log_to and I have done an timestamp interval, my problem is the NetWorksdays is one day I want to excluding the time for I have in holiday in my calculation.

Log_From                        Log_to                           Interval                  I want to have

2009-08-21 10:54:16       2009-08-26 13:42:43     05 - 02:48:27       3 - 02:48:27

It log_from is on a Saturday I want to excluding only the time not the all day.

Cheers Viktoria

0 Replies