Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Lee1
Contributor
Contributor

count the number of weekends between 2 dates

Hello

Can you help me Plz 🙂

I want to calculate the number of weekends between 2 dates

1 Solution

Accepted Solutions
sunsun566
Contributor III
Contributor III

Hi

Count({< Weekend = {"Saturday", "Sunday"}, Date =  {'>=$(=Date($(vStartDate)))<=$(=Date($(vEndDate)))'}  >}  distinct Date)

Hope it helps

View solution in original post

1 Reply
sunsun566
Contributor III
Contributor III

Hi

Count({< Weekend = {"Saturday", "Sunday"}, Date =  {'>=$(=Date($(vStartDate)))<=$(=Date($(vEndDate)))'}  >}  distinct Date)

Hope it helps