Get maximum value out of vector of variables resulting from calculated sum
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!