topic Re: Show only dimensions with max date per dimension in table diagram in App Development

Show only dimensions with max date per dimension in table diagram

jw22 — Tue, 24 Jan 2023 07:06:33 GMT

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 — Wed, 25 Jan 2023 04:01:50 GMT

try firstSortedValue()

=FirstSortedValue(TestName,-DateTime)

jw22 — Wed, 25 Jan 2023 09:21:17 GMT

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.