Show records for max date

jpjust — Mon, 29 Nov 2021 15:03:34 GMT

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!

Re: Show records for max date

jpjust — Tue, 30 Nov 2021 19:22:40 GMT

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

topic Show records for max date in App Development

Show records for max date

Re: Show records for max date