Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 (3)
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!!