Get maximum value out of vector of variables resulting from calculated sum

[#1]

So I have a data table in my app that shows for each country a score which is calculated as sum(Coefficient*Value). This gives for each country a score. Now I want to make these scores relative to the maximum value of these scores. More specifcally I want the result in my data table to be the score calculated by sum(Coefficient*Value) divided by the maximum value of these scores.

I am new to Qlik and all I could try was max(sum(Coefficient*Value)) to obtain the maximum value but this does not work. I also looked at the aggr() function, but also this did not work for me.

I would be really grateful if you could help me out!

[swuehl · Accepted solution]

Try something like

Max( Aggr( sum(Coefficient*Value), CountryField))

or in a chart with dimension CountryField

Max(TOTAL Aggr( sum(Coefficient*Value), CountryField))

[#3]

The last one works! Thank you!!!