Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gabriele_qlik
New Contributor II

VARIABLE TEXT IN CHART EXPRESSION

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

2 Replies
MVP
MVP

Re: VARIABLE TEXT IN CHART EXPRESSION

May be this

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

gabriele_qlik
New Contributor II

Re: VARIABLE TEXT IN CHART EXPRESSION

Thank you very much

Community Browser