Skip to main content

App Development

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
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.