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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Taylorcc
Contributor III
Contributor III

First Date Filter and Count

Hello, 

I have a Contact Date field and a ClientID field - one ClientID can have many Contact Dates 

I would like to find the first contact date for each ClientID 

Is this possible? 

Thank you 

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Assuming your first contact date is min date for the client, you can try like:

Dim : ClientID

Exp : Date(Min([Contact Date]))

View solution in original post

2 Replies
tresesco
MVP
MVP

Assuming your first contact date is min date for the client, you can try like:

Dim : ClientID

Exp : Date(Min([Contact Date]))

Taylorcc
Contributor III
Contributor III
Author

Thank you!!