topic Aggr & Rank - Simple Question (I think) in QlikView https://community.qlik.com/t5/QlikView/Aggr-Rank-Simple-Question-I-think/m-p/416780#M154933 <HTML><HEAD></HEAD><BODY><P>Hi Folks</P><P></P><P>I have a table with 3 dimensions and 5 measures, simples.....</P><P></P><P>One of the measures is REVs and I want to rank each entry in the table across all three dimensions, which I thought would be very simple, I have added the following calculated expression into the table:</P><P></P><P>=Aggr ( Rank ( Sum ( REVs ) , 1 , 1 ) , [Client Name], [Product], [BU Name] )</P><P></P><P>This results in an answer, but the answer makes no sense to me whatsoever, the first entry is rank 1 at 15,000,000 REVs but the second entry is also ranked 1 when the REVs are 14,398,000.&nbsp; Somewhere in the middle of the rank 1's is an entry for Rank 2 at 4,269,722 REVs and below that it goes back to rank 1 at 3,861,855 REVs.</P><P></P><P></P><P>Any clue as to what I'm doing wrong here, I'm about to lose what little sanity I have left.</P></BODY></HTML> Tue, 18 Sep 2012 09:39:50 GMT 2012-09-18T09:39:50Z Aggr & Rank - Simple Question (I think) https://community.qlik.com/t5/QlikView/Aggr-Rank-Simple-Question-I-think/m-p/416780#M154933 <HTML><HEAD></HEAD><BODY><P>Hi Folks</P><P></P><P>I have a table with 3 dimensions and 5 measures, simples.....</P><P></P><P>One of the measures is REVs and I want to rank each entry in the table across all three dimensions, which I thought would be very simple, I have added the following calculated expression into the table:</P><P></P><P>=Aggr ( Rank ( Sum ( REVs ) , 1 , 1 ) , [Client Name], [Product], [BU Name] )</P><P></P><P>This results in an answer, but the answer makes no sense to me whatsoever, the first entry is rank 1 at 15,000,000 REVs but the second entry is also ranked 1 when the REVs are 14,398,000.&nbsp; Somewhere in the middle of the rank 1's is an entry for Rank 2 at 4,269,722 REVs and below that it goes back to rank 1 at 3,861,855 REVs.</P><P></P><P></P><P>Any clue as to what I'm doing wrong here, I'm about to lose what little sanity I have left.</P></BODY></HTML> Tue, 18 Sep 2012 09:39:50 GMT https://community.qlik.com/t5/QlikView/Aggr-Rank-Simple-Question-I-think/m-p/416780#M154933 2012-09-18T09:39:50Z