Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for
Did you mean:
Creator III

## Count No. of Days in a month - problem?

###### Correct Answer  Re: Count number of Days of a Month

to get the count of Mondays for example you can simply use count({<[Day Name Field] = {'Monday'}>}  [Day Name Field]) you can do the same for the rest of the days.

Hi I looked at the answer above, but I am having trouble applying this:

I then make the table thus: I don't know what is happening!

 =Monthname(AdmDate) count(if(WeekDay(AdmDate) = 'Sat', 1)) count({<[DayAdmDate] = {'Mon'}>} [AdmDate]) Jul 2017 39 90 Aug 2017 19 55

is the problem the week day and then the month????

Jo

 MonthAdm =date(AdmDate, 'www dd/MM/yyyy') num(WeekDay(AdmDate) +1 ) (WeekDay(AdmDate) ) Jul 2017 Sat 01/07/2017 6 Sat Sun 02/07/2017 7 Sun Mon 03/07/2017 1 Mon Tue 04/07/2017 2 Tue Wed 05/07/2017 3 Wed Thu 06/07/2017 4 Thu Fri 07/07/2017 5 Fri Sat 08/07/2017 6 Sat Sun 09/07/2017 7 Sun Mon 10/07/2017 1 Mon Tue 11/07/2017 2 Tue Wed 12/07/2017 3 Wed Thu 13/07/2017 4 Thu Fri 14/07/2017 5 Fri Sat 15/07/2017 6 Sat Sun 16/07/2017 7 Sun Mon 17/07/2017 1 Mon Tue 18/07/2017 2 Tue Wed 19/07/2017 3 Wed Thu 20/07/2017 4 Thu Fri 21/07/2017 5 Fri Sat 22/07/2017 6 Sat Sun 23/07/2017 7 Sun Mon 24/07/2017 1 Mon Tue 25/07/2017 2 Tue Wed 26/07/2017 3 Wed Thu 27/07/2017 4 Thu Fri 28/07/2017 5 Fri Sat 29/07/2017 6 Sat Sun 30/07/2017 7 Sun Mon 31/07/2017 1 Mon Aug 2017 Tue 01/08/2017 2 Tue Wed 02/08/2017 3 Wed Thu 03/08/2017 4 Thu Fri 04/08/2017 5 Fri Sat 05/08/2017 6 Sat Sun 06/08/2017 7 Sun Mon 07/08/2017 1 Mon Tue 08/08/2017 2 Tue Wed 09/08/2017 3 Wed Thu 10/08/2017 4 Thu Fri 11/08/2017 5 Fri Sat 12/08/2017 6 Sat Sun 13/08/2017 7 Sun Mon 14/08/2017 1 Mon Tue 15/08/2017 2 Tue Wed 16/08/2017 3 Wed Thu 17/08/2017 4 Thu Fri 18/08/2017 5 Fri Sat 19/08/2017 6 Sat Sun 20/08/2017 7 Sun Mon 21/08/2017 1 Mon Tue 22/08/2017 2 Tue Wed 23/08/2017 3 Wed Thu 24/08/2017 4 Thu Fri 25/08/2017 5 Fri Sat 26/08/2017 6 Sat Sun 27/08/2017 7 Sun Mon 28/08/2017 1 Mon Tue 29/08/2017 2 Tue Wed 30/08/2017 3 Wed
Creator III
Author

aha - so now I have refined the problem:

I need to do a distinct AdmDate ....

 AdmDate AdmDay 25/08/2017 12:00:00 AM Fri 25/08/2017 12:00:00 AM Fri 25/08/2017 12:00:00 AM Fri 18/08/2017 12:00:00 AM Fri 18/08/2017 12:00:00 AM Fri 18/08/2017 12:00:00 AM Fri 11/08/2017 12:00:00 AM Fri 11/08/2017 12:00:00 AM Fri 11/08/2017 12:00:00 AM Fri 11/08/2017 12:00:00 AM Fri 4/08/2017 12:00:00 AM Fri 4/08/2017 12:00:00 AM Fri 4/08/2017 12:00:00 AM Fri 4/08/2017 12:00:00 AM Fri

success: