topic Re: Rank in pivot table in QlikView https://community.qlik.com/t5/QlikView/Rank-in-pivot-table/m-p/546155#M204004 <HTML><HEAD></HEAD><BODY><P>Brijesh,</P><P></P><P>The best I could do is to have rank as calculated dimension,</P><P>aggr(num(rank(sum(Amount),1)),Dim1)</P><P>and place it as the very first dimension, before Dim1.</P><P></P><P>Regards,</P><P>Michael</P></BODY></HTML> Tue, 10 Dec 2013 14:46:20 GMT Anonymous 2013-12-10T14:46:20Z Rank in pivot table https://community.qlik.com/t5/QlikView/Rank-in-pivot-table/m-p/546154#M204003 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I had 3 dimentions in a pivot table; I had used rank(sum(Amount)) expression to get rank; but while I am expanding each column of pivot table; rank is splited based on secondary dimention. It should not be splited.</P><P></P><P>In short, Rank should be based on 1st dimention only, rest of the dimentions should not be considered while ranking.(See the attached image)</P><P></P><P>Sample Data is attached.</P><P></P><P>All suggestions are welcomed.</P><P></P><P>Regards,</P><P>Brijesh</P></BODY></HTML> Mon, 09 Dec 2013 10:19:50 GMT https://community.qlik.com/t5/QlikView/Rank-in-pivot-table/m-p/546154#M204003 brijesh1991 2013-12-09T10:19:50Z Re: Rank in pivot table https://community.qlik.com/t5/QlikView/Rank-in-pivot-table/m-p/546155#M204004 <HTML><HEAD></HEAD><BODY><P>Brijesh,</P><P></P><P>The best I could do is to have rank as calculated dimension,</P><P>aggr(num(rank(sum(Amount),1)),Dim1)</P><P>and place it as the very first dimension, before Dim1.</P><P></P><P>Regards,</P><P>Michael</P></BODY></HTML> Tue, 10 Dec 2013 14:46:20 GMT https://community.qlik.com/t5/QlikView/Rank-in-pivot-table/m-p/546155#M204004 Anonymous 2013-12-10T14:46:20Z