Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

i want count the no of days in a table based on start date and end date. and skip the SAT and SUN

I have table like 

Start _Date,   End_date

01/01/2018,   21/12/2018

02/1/2018,    18/11/2018

05/01/2018,   21/02/2018


 I want count the total days between start_date and End_date  and  if there is any satday and Sunday,  skip that count..

1 Reply
Contributor II
Contributor II

Use networkdays  function.




Kindly google for more  on this function  some tie back I have see good content on this by Qlik experts