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: 
Not applicable

How to display the biggest of the numbers

If I have 3 numbers

ID Num

1     10

1      60

3      90.

Here for ID 1 i only want to display 60 which is the largest among 10 and 60.How do I do that ?

Thank you.

11 Replies
sunny_talwar

Not sure, but may be this:

=Aggr(Date(Max([Lease Expiration Date])), AB1Key)

Not applicable
Author

Sorry,but this is giving me the lease exp date instead of ABKey(which is my ID field)

sunindia