VARIABLE TEXT IN CHART EXPRESSION

[gabriele_qlik]

Hi.

I have three fields. First is a field that contain date, second is a field that contain names of the town and third contain the sum of sales.

Now I want to create a KPI with the field of the town and I want show the town with maximum sales. The maximum sales per town changes with date then the town with maximun sales changes with the date. I want that when I change date this KPI change name of the town. Thank you

[sunny_talwar]

May be this

FirstSortedValue(Town, -Aggr(Sum(Sales), Town))

[gabriele_qlik]

Thank you very much