Max index by max average in map

[Anonymous]

Hi

I want the 'max' of my map to be dynamic, according to the measure chosen.

I have a variable for the measures (var1).

The measure in the map is 'average var1 per user',  done like this:

sum($(var1))/sum(all_users)

until here all is good.

but now, I want the maximum value of the map's legend to be the value of the max 'average var1 per user' country (in order for the color ratio to make sense).

I tried something like:

max(sum(<country> $(var1))/sum(<country> all_users))

but it's not working..

Thanks in advance

[sunny_talwar]

May be this:

Max(Aggr(Sum(<country> $(var1))/Sum(<country> all_users), country))

[Oleg_Troyansky · Accepted solution]

I don't think you need the <country> prefix within an AGGR()

Max(Aggr(Sum($(var1))/Sum(all_users), country))

cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy and Austin, TX!

[sunny_talwar]

I failed to notice missing curly parenthesis, I thought it was there for ignoring selections in Country field.