How to Get Static maximum Sales "YEAR" by aggregating year's sales?

[omkarvamsi]

Hi,

I have got maximum aggregated sale's by year using below function in a Text box.

// =FirstSortedValue(year, -aggr(sum(sales), year))

when i'm selecting year in a list box,the value in text box is also changing(i.e YEAR).

But i Want the value in text box should not change(i.e maximum sale's YEAR).

[sunny_talwar · Accepted solution]

May be try this:

=FirstSortedValue({<year>}year, -Aggr(Sum({<year>}sales), year))

[omkarvamsi]

Thank you sunny,it worked

[sunny_talwar]

Awesome. If everything is resolved, please close this thread by marking the correct answer

Qlik Community Tip: Marking Replies as Correct or Helpful