2 Replies Latest reply: Jun 10, 2016 8:27 AM by Pieter Krsteff-Jantcheff RSS

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

    Pieter Krsteff-Jantcheff

      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!