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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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
tresB
Champion III
Champion III

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
tresB
Champion III
Champion III

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!!