Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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

May be like this in straight table:

Dimension: ID

Expression: Max(Num)


Capture.PNG

Not applicable
Author

Can  I do the same for the date,can I select the latest date among 2 dates ?

sunny_talwar

Sure you can, I think the only thing would be that Max(Date) would be an integer, if you want to see the date format, change it to Date(Max(Date))

Not applicable
Author

I Have max(sum(num)) ,but it still showing all 3

sunny_talwar

Not sure I understand.

You cannot double Aggregate without using Aggregation function. You need something similar to this: Max(Aggr(Sum(num), SomeDimension))

Not applicable
Author

DATE(MAX([Expiration Date],AB1Key))

Can I do something like this? My ABKey has multiple exp dates,so I only want to display the ABKey with the latest exp date .

Anonymous
Not applicable
Author

Try this

Date( RangeMax( Max([ExpirationDate]) , Max(AB1Key)))

This take the Max from the two fields.

Not applicable
Author

Thank you Edagr,but this gives an error which says error in calculated dimension.

Not applicable
Author

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

I am using the above in my dimension along with other dimensions in the straight table,but the above dimension is giving error saying error in calculated dimension.

sunindia