Show only dimensions with max date per dimension in table diagram

[jw22]

Hello Qlik community,

is there a way to only show the dimensions with the maximum/latest date per an  specific dimension in a table diagram?

In my example, I have a table as following:

For each "Production line" I only want the table to show the "Test Names" with the maximum/ latest "DateTime". 

In my example table I only want to see the green marked ones.

Thank you.

[vinieme12]

try firstSortedValue()

=FirstSortedValue(TestName,-DateTime)

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/Aggrega...

[jw22]

Hello, thank your for the reply.

I have already tried this, but then every dimension (TestName) with the latest DateTime from that dimension is shown.

I only want to show the dimensions (TestName) with the latest date per, in my case, production line.

Thank you.