topic Multiple Ranking Criteria in QlikView https://community.qlik.com/t5/QlikView/Multiple-Ranking-Criteria/m-p/459569#M171553 <HTML><HEAD></HEAD><BODY><P>Hi Qliks,</P><P></P><P>I was wondering if there is a best practice for rank calculations in case of same ranks. The given use case is a soccer scoring table, where teams may end up with the same score and ranks are assigned by a second criteria which could be the number of goals.</P><P></P><P>Any idea or sample is highly welcome</P><P></P><P>Thank you!</P><P>Florian</P></BODY></HTML> Sat, 27 Oct 2012 10:55:53 GMT 2012-10-27T10:55:53Z Multiple Ranking Criteria https://community.qlik.com/t5/QlikView/Multiple-Ranking-Criteria/m-p/459569#M171553 <HTML><HEAD></HEAD><BODY><P>Hi Qliks,</P><P></P><P>I was wondering if there is a best practice for rank calculations in case of same ranks. The given use case is a soccer scoring table, where teams may end up with the same score and ranks are assigned by a second criteria which could be the number of goals.</P><P></P><P>Any idea or sample is highly welcome</P><P></P><P>Thank you!</P><P>Florian</P></BODY></HTML> Sat, 27 Oct 2012 10:55:53 GMT https://community.qlik.com/t5/QlikView/Multiple-Ranking-Criteria/m-p/459569#M171553 2012-10-27T10:55:53Z Re: Multiple Ranking Criteria https://community.qlik.com/t5/QlikView/Multiple-Ranking-Criteria/m-p/459570#M171554 <HTML><HEAD></HEAD><BODY><P>You can calculate a new score from score and # of goals like: SCORE + GOALS / 1000</P><P></P><P>Like</P><P>TEAM, SCORE, GOALS, NEWSCORE</P><P>A, 80, 63, 80.063</P><P>B, 80, 70, 80.070</P><P>C, 77, 100, 77.100</P><P></P><P>Team B ranks highests.</P><P></P><P>If you've got multiple Criteria, you could extend this easily. You only need to define the maximum value range for each criteria, then map the results of each criteria into distinct value ranges, like</P><P>SCORE *1000 + GOALS + WON / 100</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Sat, 27 Oct 2012 11:23:31 GMT https://community.qlik.com/t5/QlikView/Multiple-Ranking-Criteria/m-p/459570#M171554 swuehl 2012-10-27T11:23:31Z