https://community.qlik.com/t5/Featured-Members/How-to-Rank-2-measure/m-p/2462835#M343 <P>it try found if same units and sales show like this&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kanchanaporn_0-1718546091360.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/167993i82F9CBB85AC7DEE4/image-size/medium?v=v2&amp;px=400" role="button" title="kanchanaporn_0-1718546091360.png" alt="kanchanaporn_0-1718546091360.png" /></span></P> <P>&nbsp;</P> Sun, 16 Jun 2024 13:56:41 GMT kanchanaporn 2024-06-16T13:56:41Z https://community.qlik.com/t5/Featured-Members/How-to-Rank-2-measure/m-p/2462814#M341 <P>How to Rank 2 measure</P> <P>Rank by units first then if units is equal &gt;&gt; rank by sales&nbsp;</P> <P>i use like this not work!!<BR />Aggr(Num(Rank(Sum(Units),Sum(Sales)), name)</P> <P>please help..</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kanchanaporn_1-1718521816795.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/167990i5DA3D14097779059/image-size/medium?v=v2&amp;px=400" role="button" title="kanchanaporn_1-1718521816795.png" alt="kanchanaporn_1-1718521816795.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Sun, 16 Jun 2024 07:14:54 GMT https://community.qlik.com/t5/Featured-Members/How-to-Rank-2-measure/m-p/2462814#M341 kanchanaporn 2024-06-16T07:14:54Z https://community.qlik.com/t5/Featured-Members/How-to-Rank-2-measure/m-p/2462831#M342 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/167898">@kanchanaporn</a>,<BR /><BR /></P> <P>Required Result:&nbsp; &nbsp; &nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TauseefKhan_0-1718540374025.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/167992i705AB185D8F10E79/image-size/medium?v=v2&amp;px=400" role="button" title="TauseefKhan_0-1718540374025.png" alt="TauseefKhan_0-1718540374025.png" /></span></P> <P>Use this:<BR />=Aggr(<BR />Rank(<BR />Sum(Unit) * 1000000 + Sum(Sales)<BR />),<BR />Name<BR />)<BR /><BR /><SPAN>***Hope this resolve your issue.</SPAN><BR /><SPAN>If the issue is solved please mark the answer with Accept as Solution &amp; like it.***</SPAN><BR /><BR /></P> <P>&nbsp;</P> <P>&nbsp;</P> Sun, 16 Jun 2024 12:22:41 GMT https://community.qlik.com/t5/Featured-Members/How-to-Rank-2-measure/m-p/2462831#M342 TauseefKhan 2024-06-16T12:22:41Z https://community.qlik.com/t5/Featured-Members/How-to-Rank-2-measure/m-p/2462835#M343 <P>it try found if same units and sales show like this&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kanchanaporn_0-1718546091360.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/167993i82F9CBB85AC7DEE4/image-size/medium?v=v2&amp;px=400" role="button" title="kanchanaporn_0-1718546091360.png" alt="kanchanaporn_0-1718546091360.png" /></span></P> <P>&nbsp;</P> Sun, 16 Jun 2024 13:56:41 GMT https://community.qlik.com/t5/Featured-Members/How-to-Rank-2-measure/m-p/2462835#M343 kanchanaporn 2024-06-16T13:56:41Z https://community.qlik.com/t5/Featured-Members/How-to-Rank-2-measure/m-p/2462841#M344 <P><SPAN>i use this it work!!!&nbsp; &nbsp;thank you for you help</SPAN></P> <P><SPAN>Aggr(</SPAN><SPAN>Rank(</SPAN><SPAN>Sum(Unit) * 1000000 + Sum(Sales),4,1</SPAN><SPAN>),</SPAN><SPAN>Name</SPAN><SPAN>)</SPAN></P> Sun, 16 Jun 2024 14:40:19 GMT https://community.qlik.com/t5/Featured-Members/How-to-Rank-2-measure/m-p/2462841#M344 kanchanaporn 2024-06-16T14:40:19Z