Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try it with: firstsortedvalue(AMOUNT, -ID)
- Marcus
Thanks Marcus!