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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 III
Specialist III

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 III
Specialist III

Show us, please!