topic Re: ranking problem in Water Cooler https://community.qlik.com/t5/Water-Cooler/ranking-problem/m-p/598305#M2510 <HTML><HEAD></HEAD><BODY><P>it works!! </P><P>thank u very much</P><P></P><P>cedric</P></BODY></HTML> Mon, 05 May 2014 18:30:04 GMT cafcptg2011 2014-05-05T18:30:04Z ranking problem https://community.qlik.com/t5/Water-Cooler/ranking-problem/m-p/598303#M2508 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How do I get the ranking value from a pivot table to text object, to understand better the my problem I have attached a qvw file .</P><P>Could someone please help me on this.</P><P>Thanks in advance,</P><P></P><P>CAFC</P></BODY></HTML> Mon, 05 May 2014 18:00:15 GMT https://community.qlik.com/t5/Water-Cooler/ranking-problem/m-p/598303#M2508 cafcptg2011 2014-05-05T18:00:15Z Re: ranking problem https://community.qlik.com/t5/Water-Cooler/ranking-problem/m-p/598304#M2509 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>=max(if(aggr(sum(Value),ARTICLE) = $(vT), aggr(rank(sum(Value)),ARTICLE)))</P></BODY></HTML> Mon, 05 May 2014 18:26:05 GMT https://community.qlik.com/t5/Water-Cooler/ranking-problem/m-p/598304#M2509 Gysbert_Wassenaar 2014-05-05T18:26:05Z Re: ranking problem https://community.qlik.com/t5/Water-Cooler/ranking-problem/m-p/598305#M2510 <HTML><HEAD></HEAD><BODY><P>it works!! </P><P>thank u very much</P><P></P><P>cedric</P></BODY></HTML> Mon, 05 May 2014 18:30:04 GMT https://community.qlik.com/t5/Water-Cooler/ranking-problem/m-p/598305#M2510 cafcptg2011 2014-05-05T18:30:04Z