Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Qliksense_User
Contributor II
Contributor II

Showing Records based on two dates

Hello

Below is my sample data

 
 
 
 
 

Capture.JPG

 I want to show contact nos based on max lead date which i can achieve easily but there are some contacts as the one in the image which has only one date ,in such scenario i want to show the contact nos based on max enquiry date. So for the contact no in the image the record with enquiry date 2-Dec-19 should be reflected in my table. Please help.

Thanx in advance.

 

 
 
 

 

Labels (1)
0 Replies