Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
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

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) )

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