Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jpjust
Specialist
Specialist

Show records for max date

Hi All,

Need a help here.

I have an qliksense table below.

jpjust_0-1638198134381.png

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!

 

1 Reply
jpjust
Specialist
Specialist
Author

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