topic Re: How to Rank Group Ranges in QlikView https://community.qlik.com/t5/QlikView/How-to-Rank-Calculated-Expressions-using-Class/m-p/1256621#M855120 <HTML><HEAD></HEAD><BODY><P>Use<STRONG> Rank(</STRONG> EXPRESSION ,<STRONG> 4,1)</STRONG></P></BODY></HTML> Sun, 12 Feb 2017 13:00:05 GMT vinieme12 2017-02-12T13:00:05Z How to Rank Calculated Expressions using Class() https://community.qlik.com/t5/QlikView/How-to-Rank-Calculated-Expressions-using-Class/m-p/1256620#M855119 <HTML><HEAD></HEAD><BODY><P>Hi Qlik Experts,</P><P></P><P>I'm looking for a workaround for these requirements can anyone give an idea.</P><P></P><P>Requirements:</P><UL><LI>UoM must be check first where range it belongs</LI><LI>Rank must be check prior to class ranges</LI><LI>In case of tied rank same number must be tag and the next rank must be numbered prior to previous rank number.</LI><LI>Note that rank method must be use, because other rank expressions must be calculated as well regardless of sorting arrangement of the table given.</LI></UL><P></P><P><STRONG>Please see attached Qlikview Document for reference TIA!</STRONG> <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Expected Ranking Result:</P><P><IMG __jive_id="152846" alt="Image 1.png" class="jive-image image-3" height="166" src="/legacyfs/online/152846_Image 1.png" style="height: 166px; width: 756.765px;" width="757" /></P><P>Qlikview Document:</P><P><IMG __jive_id="152845" alt="Image 2.png" class="jive-image image-2" height="208" src="/legacyfs/online/152845_Image 2.png" style="height: 208px; width: 758.588px;" width="759" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-Calculated-Expressions-using-Class/m-p/1256620#M855119 2020-11-25T16:16:04Z Re: How to Rank Group Ranges https://community.qlik.com/t5/QlikView/How-to-Rank-Calculated-Expressions-using-Class/m-p/1256621#M855120 <HTML><HEAD></HEAD><BODY><P>Use<STRONG> Rank(</STRONG> EXPRESSION ,<STRONG> 4,1)</STRONG></P></BODY></HTML> Sun, 12 Feb 2017 13:00:05 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-Calculated-Expressions-using-Class/m-p/1256621#M855120 vinieme12 2017-02-12T13:00:05Z Re: How to Rank Group Ranges https://community.qlik.com/t5/QlikView/How-to-Rank-Calculated-Expressions-using-Class/m-p/1256622#M855121 <HTML><HEAD></HEAD><BODY><P>Hi Vineeth,</P><P></P><P>Thanks for your response can you download my TestData.qvw and update it using your solution.. Please note that Class Ranges is calculated expressions I've also provided screenshot for the expected result TIA! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 12 Feb 2017 13:37:23 GMT https://community.qlik.com/t5/QlikView/How-to-Rank-Calculated-Expressions-using-Class/m-p/1256622#M855121 2017-02-12T13:37:23Z