Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
alknirmal1
Partner
Partner

Filter the record with maximum date from a set of records- straight table

Hi,

 

I have a straight table as shown in the screenshot where I  have multiple records for a specific case number.

I need to show only the case number with the maximum timestamp (Date Key ID) .

Is there a way to do this in the straight table?

e.g For the case number "1" I want to show only the record with the Date key id 4/2/2020

I appreciate your help on this.

 

Attached the QVW file for your reference.

 

Thanks

Nirmal

1 Solution

Accepted Solutions
Durgadevikumar
Partner
Partner

Hi Nirmal,

Good Day😊

Create the one calculated dimension to show the maximum date  records alone,

= aggr(max(Date Key ID),Case Num)  // find the maximum date  group by case number

So, now case number with maximum date records only populated in the straight table other records are eliminated.

Hope it is useful

Regards,

DurgadeviKumar

View solution in original post

1 Reply
Durgadevikumar
Partner
Partner

Hi Nirmal,

Good Day😊

Create the one calculated dimension to show the maximum date  records alone,

= aggr(max(Date Key ID),Case Num)  // find the maximum date  group by case number

So, now case number with maximum date records only populated in the straight table other records are eliminated.

Hope it is useful

Regards,

DurgadeviKumar

View solution in original post