https://community.qlik.com/t5/QlikView/Please-assist-with-a-Rank-formular/m-p/1790848#M1210619 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/134881">@Ditshele</a>, you can use an expression like:&nbsp;If(Rank(Sum(Value),1,1)=1, 'Yes','No') to set Yes to the higher. Or&nbsp;&nbsp;If(Rank(<FONT color="#FF0000">-</FONT>Sum(Value),1,1)=1, 'Yes','No') to set Yes to the lower</P> Fri, 12 Mar 2021 10:45:28 GMT rubenmarin 2021-03-12T10:45:28Z https://community.qlik.com/t5/QlikView/Please-assist-with-a-Rank-formular/m-p/1790788#M1210611 <P>Good day</P><P>Please assist with an expression to show 100 Cost Centres with the lowest Score and Highest number of customer for each quarter.</P><P>I am not familiar with the Rank function,i don't even know where to start.</P><P>&nbsp;</P><P>My grid should show&nbsp; a Cost centre and quarters(1-4) on top,If a CC falls within the category 'Yes' if not 'No'</P><P>CC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Q1&nbsp; &nbsp; &nbsp; &nbsp;Q2&nbsp; &nbsp; &nbsp;Q3&nbsp; &nbsp; &nbsp; &nbsp; Q4</P><P>321&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes&nbsp; &nbsp; &nbsp; No&nbsp; &nbsp; &nbsp; Yes&nbsp; &nbsp; &nbsp; &nbsp;Yes</P><P>003&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;No&nbsp; &nbsp; &nbsp; &nbsp; Yes&nbsp; &nbsp; &nbsp; No&nbsp; &nbsp; &nbsp; &nbsp;No</P><P>004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes&nbsp; &nbsp; &nbsp; &nbsp; No&nbsp; &nbsp; &nbsp; &nbsp; Yes&nbsp; &nbsp; &nbsp; Yes</P><P>&nbsp;</P> Fri, 12 Mar 2021 06:23:01 GMT https://community.qlik.com/t5/QlikView/Please-assist-with-a-Rank-formular/m-p/1790788#M1210611 Ditshele 2021-03-12T06:23:01Z https://community.qlik.com/t5/QlikView/Please-assist-with-a-Rank-formular/m-p/1790848#M1210619 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/134881">@Ditshele</a>, you can use an expression like:&nbsp;If(Rank(Sum(Value),1,1)=1, 'Yes','No') to set Yes to the higher. Or&nbsp;&nbsp;If(Rank(<FONT color="#FF0000">-</FONT>Sum(Value),1,1)=1, 'Yes','No') to set Yes to the lower</P> Fri, 12 Mar 2021 10:45:28 GMT https://community.qlik.com/t5/QlikView/Please-assist-with-a-Rank-formular/m-p/1790848#M1210619 rubenmarin 2021-03-12T10:45:28Z