Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Brip51
Creator
Creator

Display only row with latest date in Straight Table

Hi,

I have a straight table that can have rows with the same "Table Name" (1st col), but they can have different update dates.

I am trying to figure out how to display only the latest updated date .  In the sample below the table named 'Ultimate Loss Ratio (excludes ULAE)' has two Updated Dates.  I want to only display the 10/02/2023 date row.

Capture223.PNG

I have been struggling to figure out how to do this.  I tried FirstSortedValue, but that didn't work.

Any ideas on the best way to do this would be greatly appreciated.

Thanks,

Brian

Labels (2)
1 Solution

Accepted Solutions
pallavi_96
Partner - Contributor III
Partner - Contributor III

Hi,

You can try below expression :

Aggr(Max(Date),Table)

FirstSortedValue(Date(Date,'DD-MM-YYYY'), Aggr(Max(Date), Table))

View solution in original post

4 Replies
tincholiver
Creator III
Creator III

Did you try using max(Date) ?

Brip51
Creator
Creator
Author

Hi,

Yes.  That doesn't display only the row.

Brip51_0-1696451404612.png

Thanks,

Brian

 

pallavi_96
Partner - Contributor III
Partner - Contributor III

Hi,

You can try below expression :

Aggr(Max(Date),Table)

FirstSortedValue(Date(Date,'DD-MM-YYYY'), Aggr(Max(Date), Table))

Brip51
Creator
Creator
Author

Hi,

Yes.  That worked.  Thank you for the help on this !!!

Regards,

Brian