Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

Count of first dates

Hello

I need to count the number of episodes with a service contact date within a period (May 2020). 

I am using this logic to find the minimum service contact date for an episode: 

Date(Min([service_contact_date],episode_key))

If I filter my app by May 2020 how can I get a count of epiosde keys that have their first service contact date in that month? 

 

Thank you 

Labels (5)
3 Replies
tresesco
MVP
MVP

Try like:

Count(Distinct {<service_contact_date={'$(=Date(Min([service_contact_date]))'}>}episode_key)

Taylorcc
Contributor III
Contributor III
Author

Thanks for the response, I have tried this logic and am getting 16 when the answer should be 299.. 

tresesco
MVP
MVP

Without sample data and/or some more detail it would be hard to understand the issue. You can give a try removing 'distinct' from count() if that helps.