New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

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
Honored Contributor III

Re: Set anlaysis

FirstSortedValue(City , Sum(Sales))

Contributor

Re: Set anlaysis

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

Honored Contributor II

Re: Set anlaysis

what object type are you using?

Contributor

Re: Set anlaysis

KPI

Honored Contributor II

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

Valued Contributor III

Re: Set anlaysis

Hi Aaron,

Try something like

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

Mark