Max Price Vs. Least Price in Year

[QlikAngel]

Please find attach sample data with in sheet 2 required output

[tresesco · Accepted solution]

Try:

Max Purchase Date Price: FirstSortedValue({<Year={'$(=Max(Year))'}>} [Unit Price], -Date)

Min Price: Min({<Year={'$(=Max(Year))'}>} [Unit Price])