Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try something like

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


or in a chart with dimension CountryField


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



View solution in original post

2 Replies
swuehl
MVP
MVP

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
Author

The last one works! Thank you!!!