topic Re: Can we set rank on Second dimension in Dimension Drill Down Group in QlikView https://community.qlik.com/t5/QlikView/Can-we-set-rank-on-Second-dimension-in-Dimension-Drill-Down/m-p/1445702#M433261 <HTML><HEAD></HEAD><BODY><P>Perhaps this?</P><P><STRONG style="color: #666666; font-family: Helvetica, Arial, sans-serif; font-size: 14px;">If(GetCurrentField([Drill group Name]) = 'Country', Sum(Measure), If(Rank(Sum(<STRONG style="color: #666666; font-family: Helvetica, Arial, sans-serif; font-size: 14px;">Measure</STRONG>)) &lt;= 5, Sum(<STRONG style="color: #666666; font-family: Helvetica, Arial, sans-serif; font-size: 14px;">Measure</STRONG>)))</STRONG></P></BODY></HTML> Thu, 09 Nov 2017 12:50:48 GMT Anil_Babu_Samineni 2017-11-09T12:50:48Z Can we set rank on Second dimension in Dimension Drill Down Group https://community.qlik.com/t5/QlikView/Can-we-set-rank-on-Second-dimension-in-Dimension-Drill-Down/m-p/1445700#M433259 <HTML><HEAD></HEAD><BODY><P>I have got the requirement&nbsp; that we have shown Group of&nbsp; dimension as<STRONG> Drill Down Group&nbsp; </STRONG>and&nbsp; set the rank on second dimension,</P><P></P><P></P><P>Suppose we have 2 dimension&nbsp; here,</P><P></P><P>1)Country</P><P>2)Sales Person </P><P></P><P>We have defined the drill down group on above dimension </P><P></P><P>if&nbsp; i click on country&nbsp; then we&nbsp; should have only T<STRONG>op 5</STRONG> sales person.</P></BODY></HTML> Thu, 09 Nov 2017 12:46:20 GMT https://community.qlik.com/t5/QlikView/Can-we-set-rank-on-Second-dimension-in-Dimension-Drill-Down/m-p/1445700#M433259 alis2063 2017-11-09T12:46:20Z Re: Can we set rank on Second dimension in Dimension Drill Down Group https://community.qlik.com/t5/QlikView/Can-we-set-rank-on-Second-dimension-in-Dimension-Drill-Down/m-p/1445701#M433260 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>If(GetCurrentField([GroupName]) = 'Country', Sum(Sales), If(Rank(Sum(Sales)) &lt; 6, Sum(Sales)))</STRONG></P></BODY></HTML> Thu, 09 Nov 2017 12:49:13 GMT https://community.qlik.com/t5/QlikView/Can-we-set-rank-on-Second-dimension-in-Dimension-Drill-Down/m-p/1445701#M433260 sunny_talwar 2017-11-09T12:49:13Z Re: Can we set rank on Second dimension in Dimension Drill Down Group https://community.qlik.com/t5/QlikView/Can-we-set-rank-on-Second-dimension-in-Dimension-Drill-Down/m-p/1445702#M433261 <HTML><HEAD></HEAD><BODY><P>Perhaps this?</P><P><STRONG style="color: #666666; font-family: Helvetica, Arial, sans-serif; font-size: 14px;">If(GetCurrentField([Drill group Name]) = 'Country', Sum(Measure), If(Rank(Sum(<STRONG style="color: #666666; font-family: Helvetica, Arial, sans-serif; font-size: 14px;">Measure</STRONG>)) &lt;= 5, Sum(<STRONG style="color: #666666; font-family: Helvetica, Arial, sans-serif; font-size: 14px;">Measure</STRONG>)))</STRONG></P></BODY></HTML> Thu, 09 Nov 2017 12:50:48 GMT https://community.qlik.com/t5/QlikView/Can-we-set-rank-on-Second-dimension-in-Dimension-Drill-Down/m-p/1445702#M433261 Anil_Babu_Samineni 2017-11-09T12:50:48Z Re: Can we set rank on Second dimension in Dimension Drill Down Group https://community.qlik.com/t5/QlikView/Can-we-set-rank-on-Second-dimension-in-Dimension-Drill-Down/m-p/1445703#M433262 <HTML><HEAD></HEAD><BODY><P>Thanks for you help.</P></BODY></HTML> Thu, 09 Nov 2017 13:27:16 GMT https://community.qlik.com/t5/QlikView/Can-we-set-rank-on-Second-dimension-in-Dimension-Drill-Down/m-p/1445703#M433262 alis2063 2017-11-09T13:27:16Z Re: Can we set rank on Second dimension in Dimension Drill Down Group https://community.qlik.com/t5/QlikView/Can-we-set-rank-on-Second-dimension-in-Dimension-Drill-Down/m-p/1445704#M433263 <HTML><HEAD></HEAD><BODY><P>Thanks for your help</P></BODY></HTML> Thu, 09 Nov 2017 13:27:31 GMT https://community.qlik.com/t5/QlikView/Can-we-set-rank-on-Second-dimension-in-Dimension-Drill-Down/m-p/1445704#M433263 alis2063 2017-11-09T13:27:31Z