Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
aaronnayan
Contributor III

Set anlaysis

Hi Guys

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

Not the sales number

1 Solution

Accepted Solutions
Highlighted

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
Partner

Re: Set anlaysis

FirstSortedValue(City , Sum(Sales))

aaronnayan
Contributor III

Re: Set anlaysis

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

Partner
Partner

Re: Set anlaysis

what object type are you using?

aaronnayan
Contributor III

Re: Set anlaysis

KPI

Partner
Partner

Re: Set anlaysis

maybe this:

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

Highlighted

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
Partner

Re: Set anlaysis

Hi Aaron,

Try something like

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

Mark