Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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

View solution in original post