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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count number of days in a given period/month

I have a pivot table which contains the dimension month and multiple expressions that sum sales for a certain year. I want to calculate the number of days in a month, COUNT ([Invoice date]) will give the count of all invoice dates in a related period. I would like to know the number of days in a certain month, let's say 31 days for January.

1 Reply
swuehl
MVP
MVP

Maybe

=day(monthend(max([Invoice date])))