Discussion Board for collaboration related to QlikView App Development.
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.
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
View solution in original post