Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mohammadkhatimi
Partner - Specialist
Partner - Specialist

Count of Saturday in whole month

For Example,

April 2016 has 30 days and 5 Saturdays.

I want to count only those 5 Saturdays,even if they aren't passed.

For instance today is(4th Apr 2016) Still the count should be 5 Saturdays.

This should work for every month.

Regards,

Mohammad

15 Replies
mohammadkhatimi
Partner - Specialist
Partner - Specialist
Author

I dont have the data for the future saturdays that's the main problem.

Kindly help me with this issue... for the future saturdays only for the current month.

mohammadkhatimi
Partner - Specialist
Partner - Specialist
Author

I want to do this in the master calendar. My date is linked with Master Calendar, so the data wont be there for future dates.

So I want the solution which will help me to count the saturdays.. which are not present in the dates.

swuehl
MVP
MVP

Ok, but could you clarify why my suggested expression using Div() is not working for you?

For example, if you are using a SalesDate field and what to get the number of saturdays in the month the SalesDate is located in, you should be able to use something like

=Div(WEEKDAY(Monthstart(SalesDate)-6)+1-Monthstart(SalesDate)+Floor(MonthEnd(SalesDate)),7)


[Used e.g. in an expression in a chart with dimension SalesDate, or in a text box with a single SalesDate selected. Use aggregation functions like Max() around SalesDate when there are multiple SalesDate in the record set of your expression's scope]


Maybe you can just post some sample records with your expected results to understand better what your issue is.

Not applicable

You need to create the Future dates

It was answered in this previous post :

Past and future dates in the same table

mohammadkhatimi
Partner - Specialist
Partner - Specialist
Author

Thank you...

cspindley
Contributor III
Contributor III

on behalf of the nhs thanQ for sharing for free ...