Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Contributor II
Contributor II

Use networkdays  function.

 

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...

 

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