Solved: Re: Set anlaysis - Qlik Community

aaronnayan · ‎2017-11-21

Hi Guys

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

Not the sales number

sunny_talwar · ‎2017-11-21

May be this

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

or

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

shraddha_g · ‎2017-11-21

FirstSortedValue(City , Sum(Sales))

aaronnayan · ‎2017-11-21

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

agigliotti · ‎2017-11-21

what object type are you using?

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it

aaronnayan · ‎2017-11-21

KPI

agigliotti · ‎2017-11-21

maybe this:

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it

sunny_talwar · ‎2017-11-21

May be this

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

or

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

Mark_Little · ‎2017-11-21

Hi Aaron,

Try something like

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

Mark