# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Contributor III

## Set anlaysis

Hi Guys

How would i show which City as a Value has the highest sales ?

Not the sales number

Tags (6)
1 Solution

Accepted Solutions
MVP

## Re: Set anlaysis

May be this

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

or

Concat(Aggr(If(Sum(Sales) = Max(TOTAL Aggr(Sum(Sales), City), City), City), ', ')

7 Replies
Partner

## Re: Set anlaysis

FirstSortedValue(City , Sum(Sales))

Highlighted
Contributor III

## Re: Set anlaysis

I need it to show the city that has the highest sales

Partner

## Re: Set anlaysis

what object type are you using?

Contributor III

KPI

Partner

## Re: Set anlaysis

maybe this:

=Only( Aggr( if( Sum(Sales) =  Max( total Aggr( Sum(Sales), City) ), City, Null() ), City) )

MVP

## Re: Set anlaysis

May be this

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

or

Concat(Aggr(If(Sum(Sales) = Max(TOTAL Aggr(Sum(Sales), City), City), City), ', ')

Partner

## Re: Set anlaysis

Hi Aaron,

Try something like

IF(RANK(AGGR(SUM(SALES),CITY) = 1,ONLY(CITY))

Mark