topic Re: Max index by max average in map in QlikView

Max index by max average in map

Anonymous — Mon, 22 Feb 2016 17:10:14 GMT

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

Re: Max index by max average in map

sunny_talwar — Mon, 22 Feb 2016 17:28:45 GMT

May be this:

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

Re: Max index by max average in map

Oleg_Troyansky — Mon, 22 Feb 2016 17:39:25 GMT

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!

Re: Max index by max average in map

sunny_talwar — Mon, 22 Feb 2016 17:41:29 GMT

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