topic Re: Rank Function with variable in QlikView https://community.qlik.com/t5/QlikView/Rank-Function-with-variable/m-p/1412532#M427007 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>Please, see the attachement. Is this what you want to get?</P><P><IMG alt="rank_aggr.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182120_rank_aggr.png" style="height: 190px; width: 620px;" /></P></BODY></HTML> Sat, 04 Nov 2017 19:08:14 GMT Sergey_Shuklin 2017-11-04T19:08:14Z Rank Function with variable https://community.qlik.com/t5/QlikView/Rank-Function-with-variable/m-p/1412531#M427006 <HTML><HEAD></HEAD><BODY><P>Dear Experts ,</P><P></P><P>I am not able to use the variable in rank expression .</P><P></P><P>I want to search the top 5 ranks in date which is less than or equal to&nbsp; vdt ( date passed ). </P><P></P><P>=aggr(if(Rank(Sum(qty))&lt;=5,qty ),&nbsp; (pdate&lt;=vdt)&nbsp; )&nbsp;&nbsp; </P><P></P><P>=aggr(if(Rank(Sum(qty))&lt;=5,qty ),&nbsp; pdate&nbsp; ) is working fine but I am not able to restrict the pdate .</P><P></P><P>Pleas suggest.</P><P></P><P>Thanks.</P><P></P><P>Best Regards,</P><P>Milind.&nbsp; </P></BODY></HTML> Sat, 04 Nov 2017 07:59:11 GMT https://community.qlik.com/t5/QlikView/Rank-Function-with-variable/m-p/1412531#M427006 milindnikumbh 2017-11-04T07:59:11Z Re: Rank Function with variable https://community.qlik.com/t5/QlikView/Rank-Function-with-variable/m-p/1412532#M427007 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>Please, see the attachement. Is this what you want to get?</P><P><IMG alt="rank_aggr.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/182120_rank_aggr.png" style="height: 190px; width: 620px;" /></P></BODY></HTML> Sat, 04 Nov 2017 19:08:14 GMT https://community.qlik.com/t5/QlikView/Rank-Function-with-variable/m-p/1412532#M427007 Sergey_Shuklin 2017-11-04T19:08:14Z Re: Rank Function with variable https://community.qlik.com/t5/QlikView/Rank-Function-with-variable/m-p/1412533#M427008 <HTML><HEAD></HEAD><BODY><P>Thanks. Very helpful . My issue is resolved using this expression.</P></BODY></HTML> Mon, 06 Nov 2017 03:13:51 GMT https://community.qlik.com/t5/QlikView/Rank-Function-with-variable/m-p/1412533#M427008 milindnikumbh 2017-11-06T03:13:51Z