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
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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: 
Not applicable
‎2013-03-20 10:29 AM

Exlude Friday & Saturday

Hi,

How to exclude Friday and Saturday weekday.

Suppose I have the Date from Start Date - 01/01/2013 to End Date - 31/03/2013.

Note : I want the count of day including Saturday and Sunday.

Thanks & Regards,

Amit Kumar

Labels (1)
Labels
2,015 Views
0 Likes
10 Replies
rbecher
Partner - Master III
Partner - Master III
‎2013-03-20 03:57 PM

Hi Amit,

maybe this helps: shift the start and end date (consider Friday and Saturday as Weekend)

= networkdays(StartDate +1, EndDate +1)

- Ralf

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine
1,785 Views
0 Likes