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

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
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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: 
Sumit2504
Contributor III
Contributor III
‎2021-04-18 11:50 PM

Working Days in DD/MM/YYYY format

Hi All,

I want to calculate No of working days in DD/MM/YYYY format.

For example - My starting date is 01/Jan/2020 and Last date is 31/Jan/2020 so i want list of all working days in DD/MMM/YYYY.

 

 

Regards,

Sumit

2,270 Views
0 Likes
10 Replies
tresB
Champion III
Champion III
‎2021-04-19 06:25 AM

Same load:

If(Not Match(WeekDay(Date),'Sat', 'Sun') And IsNull(ApplyMap('Map', Date,null())), Date) as WorkingDay,

Day(If(Not Match(WeekDay(Date),'Sat', 'Sun') And IsNull(ApplyMap('Map', Date,null())), Date)) as Day

332 Views