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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how do i count the number of date entries that have the same month and year as the current date using set analysis?

how do i count the number of date entries that have the same month and year as the current date using set analysis?

1 Reply
jpapador
Partner - Specialist
Partner - Specialist

Try This:

=Count({$<Year={$(=Year(Today()))}, Month={$(=Month(Today()))}>}[Date Entry Field])

This is assuming you have a field called 'Year' and 'Month'.  If you don't it is easy to create.