Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Show only dimensions with max date per dimension in table diagram

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.

Labels (1)
2 Replies
Champion III
Champion III

try firstSortedValue()


Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Contributor II
Contributor II

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.