Solved: count the number of weekends between 2 dates - Qlik Community

Lee1 · ‎2020-10-19

Hello

Can you help me Plz 🙂

I want to calculate the number of weekends between 2 dates

sunsun566 · ‎2020-10-19

Hi

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

Hope it helps

sunsun566 · ‎2020-10-19

Hi

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

Hope it helps