Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jw22
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:

jw22_0-1674543764180.png

 

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
vinieme12
Champion III
Champion III

try firstSortedValue()

=FirstSortedValue(TestName,-DateTime)

 

 

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

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

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.