Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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!

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

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

Try something like

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


or in a chart with dimension CountryField


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



2 Replies
MVP
MVP

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

Try something like

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


or in a chart with dimension CountryField


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



Not applicable

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

The last one works! Thank you!!!