Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try something like
Max( Aggr( sum(Coefficient*Value), CountryField))
or in a chart with dimension CountryField
Max(TOTAL Aggr( sum(Coefficient*Value), CountryField))
Try something like
Max( Aggr( sum(Coefficient*Value), CountryField))
or in a chart with dimension CountryField
Max(TOTAL Aggr( sum(Coefficient*Value), CountryField))
The last one works! Thank you!!!