Qlik Sense Table box

[Qlikuser225]

Hello All,

Can you please help me how to get the max date records with the value greater than 5 in table box?

For example:

Name   ID    State       Date                  Value

AAA    213      NY         04/06/2023       6

AAA    213      NY         04/23/2023        8

BBB   434      CA        05/06/2023          8

BBB   434      CA        05/08/2023          4

I want to show in the table box only below record because only it has max date with value greater than 5; I cannot show ID BBB on date 05/08/2023 because value is less than 5.

Name   ID    State       Date                  Value

AAA    213      NY         04/23/2023       8

Can you please help me to understand how to achieve the results.

Thanks, in advance.

[Chanty4u]

You can use below 

Date: =Max({<Value={">5"}>} Date)

Value: =Max({<Value={">5"}, Date={$(=Max({<Value={">5"}>} Date))}>} Value)

[Qlikuser225]

Thanks for your reply, unfortunately it's not working as expected.

[Chanty4u]

Can you try this 

=aggr(

  if( Value > 5,

    if(  Date = max({<Value={">5"}>} Date),      Name    )  ),

  Name, ID, State, Date,

Value)

[Qlikuser225]

Thanks, i used the formula as expression and it still not working 😞

[Chanty4u]

Try this 

=aggr(

  if(Date = max({<Value={">5"}>} Date), Name & ' ' & ID & ' ' & State & ' ' & Date & ' ' & Value),

  ID

)

[Qlikuser225]

Hello, still no luck