Show records for max date

[jpjust]

Hi All,

Need a help here.

I have an qliksense table below.

What I want to show is only the record that the app was analyzed last (createddatetime) . That means, from the table it should show just the record for 2021-11-24

The App Name field has already the following expression =Aggr(Only({<[App Publish Date] = {'$(=Date(Today(),'YYYY-MM-DD'))'}>}[AppNameUnique]),[AppNameUnique])

Please let me know how to achieve the desired result.

Thanks very much!

[jpjust]

Hi,

Anyone has any idea ?

I tried using Firstsortedvalue.

And expression like below but nothing helps.

The following expression do not bring app's that has no "createdDateTime"

=if(Aggr(NODISTINCT max(createdDateTime),AppNameUnique)=createdDateTime,createdDateTime)

Any solution to this will be helpful.

Thanks