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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Just6
Contributor II
Contributor II

Count saturdays in a intervall

Hello all,

I would like to count the number of Saturdays between the start and end date.

Thanks!

Labels (1)
4 Replies
F_B
Specialist II
Specialist II

Chanty4u
MVP
MVP

Spoiler
 

Try this

Count({<DateField = {"$(=Date(Start_Date, 'YYYY-MM-DD'))<=$(=Date(End_Date, 'YYYY-MM-DD'))"}, WeekDay = {'6'}>} DateField)

 

Just6
Contributor II
Contributor II
Author

No sorry, I found another way better. 

F_B
Specialist II
Specialist II

Show us, please!