topic Re: How to Rank by Lowest number first in QlikView https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245164#M93482 <HTML><HEAD></HEAD><BODY><P> I dont know if this helps. </P><P></P><P>Marcus</P></BODY></HTML> Wed, 01 Feb 2012 21:06:12 GMT Anonymous 2012-02-01T21:06:12Z How to Rank by Lowest number first https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245163#M93481 <HTML><HEAD></HEAD><BODY><P>Hi, I am just at my wits end on this...&nbsp; I am using a calculated dimension to give a numerical rank to Hospitals based on a score.&nbsp;&nbsp; The problem is that the Rank formula seems to only work in decending order so the highest score is ranked 1... what i need is the reverse the lowest score should be ranked 1.</P><P></P><P>Here is my expression in the calculated dimension</P><P></P><P>=aggr(rank(Total Aggr((sum(Score)), hospital),0,1), hospital)</P><P></P><P>Any help would be much appreciated. </P><P></P><P>by the way i have tried the following but it still won't work</P><P></P><P>=aggr(rank(Total Aggr(((sum(Score) * -1)), hospital),0,1), hospital)</P><P></P><P>thanks, </P></BODY></HTML> Wed, 01 Feb 2012 20:31:17 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245163#M93481 2012-02-01T20:31:17Z Re: How to Rank by Lowest number first https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245164#M93482 <HTML><HEAD></HEAD><BODY><P> I dont know if this helps. </P><P></P><P>Marcus</P></BODY></HTML> Wed, 01 Feb 2012 21:06:12 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245164#M93482 Anonymous 2012-02-01T21:06:12Z How to Rank by Lowest number first https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245165#M93483 <HTML><HEAD></HEAD><BODY><P>I also believe that negating the sum(Score) should do what you want (like in Marcus example).</P><P></P><P>I also think that you don't need the inner aggr() function, probably</P><P>=aggr( rank(-sum(Score) ,0,1), hospital)</P><P></P><P>should be enough.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Wed, 01 Feb 2012 21:42:58 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245165#M93483 swuehl 2012-02-01T21:42:58Z How to Rank by Lowest number first https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245166#M93484 <HTML><HEAD></HEAD><BODY><P>well i think i am getting closer... but now the problem is that the rankings seem to start at 28 rather then at 1 but the order is right</P><P><IMG src="https://community.qlik.com/" /></P></BODY></HTML> Wed, 01 Feb 2012 22:24:02 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245166#M93484 2012-02-01T22:24:02Z Re: How to Rank by Lowest number first https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245167#M93485 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>can you post a .qvw file containing your problem?</P></BODY></HTML> Wed, 01 Feb 2012 22:29:35 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245167#M93485 Anonymous 2012-02-01T22:29:35Z Re: How to Rank by Lowest number first https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245168#M93486 <HTML><HEAD></HEAD><BODY><P>Ok here is a QVW file..&nbsp;&nbsp; So as you can see the calculated dimention works with you choose "Decubitus Ulcer" and ranks the hospitals 1,2,3,4 but when you choose " Post-op Sepsis"&nbsp; the ranking starts at 2 rather then 1. </P></BODY></HTML> Tue, 07 Feb 2012 21:36:34 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245168#M93486 2012-02-07T21:36:34Z How to Rank by Lowest number first https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245169#M93487 <HTML><HEAD></HEAD><BODY><P>Rank 1 is assigned to Hosp A, but the expression value avg(raj) is zero. Since you suppress zero values in presentation tab, this line is hidden.</P></BODY></HTML> Tue, 07 Feb 2012 21:44:26 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/245169#M93487 swuehl 2012-02-07T21:44:26Z Re: How to Rank by Lowest number first https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/1531343#M438758 <P>Thanks,&nbsp;</P><P>Negation worked for me <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 17 Jan 2019 06:25:59 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-by-Lowest-number-first/m-p/1531343#M438758 anu 2019-01-17T06:25:59Z