Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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