Limit straight table with dimensions to only the most recent data

[santho_ak]

Hello. I am working on a straight table with around 20+ dimensions and there are no measures. Is there any way to limit the straight table to show only the most recent record only.

Eg of current Qlik staright table:

EmpID |  RequestID | City 

1                   10                 Newyork

1                   11                 Madison

2                   12                 Washington

3                   13                 Seattle

3                   14                  Jersey City

I have a UniqueID field which is always auto generated based on most recent time stamp. But my requirement doesn't have to display that UniqueID field. Any idea or recommendations would be helpful to display only the most recent record only. Thanks

Desired Output:

EmpID | City 

1                Madison

2                 Washington

3                  Jersey City

[Kushal_Chawda]

@santho_ak  can you please elaborate? It is bit confusing that you don't want to show one column and want to show latest updated records only which is quite a different thing

[Neymar_Jr]

Changing the City dimension to the below should work- 

aggr(only({<RequestID = {$(=concat(distinct aggr(max(RequestID),EmpID),','))}>}City),EmpID)