topic Re: Ranks for Dimensions for two levels in QlikView https://community.qlik.com/t5/QlikView/Ranks-for-Dimensions-for-two-levels/m-p/753659#M1026092 <HTML><HEAD></HEAD><BODY><P>Hi Anbu,</P><P></P><P>Thanks you very much ..!!! It's helpful for me..!!! Thanks for your quick response.</P></BODY></HTML> Fri, 06 Mar 2015 07:14:31 GMT 2015-03-06T07:14:31Z Ranks for Dimensions for two levels https://community.qlik.com/t5/QlikView/Ranks-for-Dimensions-for-two-levels/m-p/753657#M1026090 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am new to QlikView. I am facinga problem to generate a ranks for two leveled dimesions .Hers is the Example I want to generate a rank to the GROUP based on the Total Sum w.r.t the Group. Reqeust you all to help me on this</P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 476px; BORDER-COLLAPSE: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="background-color: yellow; width: 41pt; height: 12.75pt; border: windowtext 0.5pt solid;" width="55"><STRONG style="color: #333333; font-family: Calibri;">Group</STRONG></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: yellow; width: 34pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="45"><STRONG style="color: #333333; font-family: Calibri;">Month</STRONG></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: yellow; width: 44pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="59"><STRONG style="color: #333333; font-family: Calibri;">Sum</STRONG></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: yellow; width: 71pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="95"><STRONG style="color: #333333; font-family: Calibri;">Rank on Sum</STRONG></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: yellow; width: 167pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="222"><STRONG style=": ; color: #333333; font-family: Calibri;">Ranks For Groups based on Total Sum<SPAN style="mso-spacerun: yes;"> </SPAN></STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">A</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">1</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">17</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">2</SPAN></TD><TD class="xl64" rowspan="4" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: yellow; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">2</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">A</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">4</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">16</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">3</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">A</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">7</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">11</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">4</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">A</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">8</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">20</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">1</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">A</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">Total</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">64</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">-</STRONG></TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: yellow; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">-</STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">B</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">2</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">9</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">3</SPAN></TD><TD class="xl64" rowspan="4" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: yellow; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">4</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">B</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">3</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">22</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">1</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">B</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">5</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">10</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">2</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">B</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">6</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">5</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">4</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">B</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">Total</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">46</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">-</STRONG></TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: yellow; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">-</STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">D</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">1</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">21</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">1</SPAN></TD><TD class="xl64" rowspan="4" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: yellow; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">1</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">D</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">2</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">18</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">2</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">D</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">5</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">15</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">3</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">D</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">8</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">12</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">4</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">D</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">Total</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">66</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">-</STRONG></TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: yellow; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">-</STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">E</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">3</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">10</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">3</SPAN></TD><TD class="xl64" rowspan="4" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: yellow; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">3</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">E</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">4</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">21</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">1</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">E</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">6</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">11</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">2</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">E</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">7</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">6</SPAN></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: white; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">4</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: white; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">E</SPAN></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">Total</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">48</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: whitesmoke; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">-</STRONG></TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: yellow; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000; font-family: Calibri;">-</STRONG></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 05 Mar 2015 18:03:49 GMT https://community.qlik.com/t5/QlikView/Ranks-for-Dimensions-for-two-levels/m-p/753657#M1026090 2015-03-05T18:03:49Z Re: Ranks for Dimensions for two levels https://community.qlik.com/t5/QlikView/Ranks-for-Dimensions-for-two-levels/m-p/753658#M1026091 <HTML><HEAD></HEAD><BODY><P>Aggr(Rank(Sum(Sum)),Group)</P></BODY></HTML> Fri, 06 Mar 2015 06:05:31 GMT https://community.qlik.com/t5/QlikView/Ranks-for-Dimensions-for-two-levels/m-p/753658#M1026091 anbu1984 2015-03-06T06:05:31Z Re: Ranks for Dimensions for two levels https://community.qlik.com/t5/QlikView/Ranks-for-Dimensions-for-two-levels/m-p/753659#M1026092 <HTML><HEAD></HEAD><BODY><P>Hi Anbu,</P><P></P><P>Thanks you very much ..!!! It's helpful for me..!!! Thanks for your quick response.</P></BODY></HTML> Fri, 06 Mar 2015 07:14:31 GMT https://community.qlik.com/t5/QlikView/Ranks-for-Dimensions-for-two-levels/m-p/753659#M1026092 2015-03-06T07:14:31Z