Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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 

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: First Date Filter and Count

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
Highlighted
MVP
MVP

Re: First Date Filter and Count

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

Highlighted
Contributor II
Contributor II

Re: First Date Filter and Count

Thank you!!