topic To Display in text object max(cost) corresponding with year in QlikView

To Display in text object max(cost) corresponding with year

Hareeshkommineni — Wed, 25 Nov 2020 16:16:04 GMT

LOAD * INLINE [
Year, cost
2010, 1000
2013, 2000
2014, 9000
2016, 6000
2018, 5000

];

i want to add missing years and

I want output like this in text object

2014=9000

sunny_talwar — Wed, 27 Feb 2019 13:08:10 GMT

Try this

=FirstSortedValue(Year, -Aggr(Sum(cost), Year)) & '=' & Max(Aggr(Sum(cost), Year))

sunny_talwar — Wed, 27 Feb 2019 13:09:59 GMT

Or this if you only have a single cost for each year

=FirstSortedValue(Year, -cost) & '=' & Max(cost)

Hareeshkommineni — Wed, 27 Feb 2019 13:41:19 GMT

tq so much
it's very usefull