topic Limit straight table with dimensions to only the most recent data in App Development

Limit straight table with dimensions to only the most recent data

santho_ak — Sat, 16 Nov 2024 18:07:03 GMT

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

Re: Limit straight table with dimensions to only the most recent data

Kushal_Chawda — Sat, 12 Sep 2020 21:13:39 GMT

@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

Re: Limit straight table with dimensions to only the most recent data

Neymar_Jr — Sun, 13 Sep 2020 05:45:06 GMT

Changing the City dimension to the below should work-

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