Select Max Value to display in text object

[martin_hamilton]

Hi

Am trying to display a value in a text object based on the maximum value contained in the column which is the latest ID number:

The data is below:

ID, AMOUNT

1, 63636

2,83838

3,75757

I would like the value of 75757 displayed in the text box.

I have the following expression so far but cant figure out how to show the AMOUNT rather than the ID max number!

=Max (ID, AMOUNT)

Am new to Qlikview so please excuse me!

thanks

Martin

[marcus_sommer]

Try it with: firstsortedvalue(AMOUNT, -ID)

- Marcus

[martin_hamilton]

Thanks Marcus!