Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count number of Days of a Month

Hi

a) I need to do an average from some data. But for this, I need to know how many days are in a certain month.

     How can I get this number?

i.e. February 2014   -->  28 (days)

b) I need to get the number of Mondays,Tuesday, and so on in a certain month. ¿How can I get this?

i.e. January 2014 --> 5 Mondays

      January 2014 --> 4 Tuesday

      January 2014 --> 4 Wednesday

1 Solution

Accepted Solutions
maleksafa
Specialist
Specialist

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.

View solution in original post

3 Replies
Not applicable
Author

I'm using a Master Calendar for my dates.

It has the following fields:

a) %Date Field                         25-01-2014, 26-01-2014

b) Day Name field               Monday,Friday,Tuesday

c) Month                             January, February...

(and much more)

Not applicable
Author

Hi,

1) Max(day(datefield)) - Min(day(datefield))

maleksafa
Specialist
Specialist

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.