topic Re: rank in QlikView https://community.qlik.com/t5/QlikView/rank/m-p/426440#M158862 <HTML><HEAD></HEAD><BODY><P>Great, Thanks swuehl!</P></BODY></HTML> Tue, 12 Feb 2013 16:28:43 GMT alexpanjhc 2013-02-12T16:28:43Z rank https://community.qlik.com/t5/QlikView/rank/m-p/426437#M158859 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I am not able to figure out the rank, hrank functions.</P><P></P><P>I have a pivot table that I have 2 demisions.</P><P>but I need to rank the entire pivot table.</P><P></P><P>It looks like rank() only rankd the columns and hrank() ranks the rows.</P><P>I need to rank the entire piovt table, how do I do that?</P><P>Thanks!</P></BODY></HTML> Mon, 11 Feb 2013 22:08:04 GMT https://community.qlik.com/t5/QlikView/rank/m-p/426437#M158859 alexpanjhc 2013-02-11T22:08:04Z Re: rank https://community.qlik.com/t5/QlikView/rank/m-p/426438#M158860 <HTML><HEAD></HEAD><BODY><P>what You mean <STRONG>rank entire pivot table?</STRONG></P><P></P><P>could You describe Your objects/expressions/dimensions?</P></BODY></HTML> Tue, 12 Feb 2013 07:46:25 GMT https://community.qlik.com/t5/QlikView/rank/m-p/426438#M158860 2013-02-12T07:46:25Z Re: rank https://community.qlik.com/t5/QlikView/rank/m-p/426439#M158861 <HTML><HEAD></HEAD><BODY><P>Try using something like</P><P></P><P>=aggr( rank(TOTAL sum(Value)), DIM1, DIM2)</P><P></P><P>where you list all your table dimension fields in the aggr() function (replacing DIM1, DIM2 with the dimension fields).</P></BODY></HTML> Tue, 12 Feb 2013 09:00:04 GMT https://community.qlik.com/t5/QlikView/rank/m-p/426439#M158861 swuehl 2013-02-12T09:00:04Z Re: rank https://community.qlik.com/t5/QlikView/rank/m-p/426440#M158862 <HTML><HEAD></HEAD><BODY><P>Great, Thanks swuehl!</P></BODY></HTML> Tue, 12 Feb 2013 16:28:43 GMT https://community.qlik.com/t5/QlikView/rank/m-p/426440#M158862 alexpanjhc 2013-02-12T16:28:43Z