topic Ranking within a subset selected by a user in QlikView https://community.qlik.com/t5/QlikView/Ranking-within-a-subset-selected-by-a-user/m-p/300331#M1202828 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>This issue gave me some difficulties. I need some help.</P><P>Suppose we have a file with this fields</P><P>- Region</P><P>- Region_Size (5 different values)</P><P>- City (a city belongs to a Region)</P><P>- City_Status (2 values 1 or 2)</P><P>- HH (households)</P><P>In my application, the user have to select a unique Region.</P><P>I want to display a chart (table) with this informations :</P><P>- City_Status</P><P>- The Rank of the Cities among all the Regions with the same Region_Size that my Selected Region</P><TABLE border="0" cellpadding="0" cellspacing="0" style="height: 51px;" width="227"><COL style="width: 60pt;" width="80" /><COL style="width: 58pt;" width="77" /><COL style="width: 53pt;" width="70" /><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl23" height="17" style="height: 12.75pt; width: 60pt;" width="80"><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3295_sourceID:3295" /></TD><TD class="xl23" style="width: 58pt;" width="77"></TD><TD class="xl24" style="width: 53pt;" width="70"></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl22" height="17" style="height: 12.75pt;"></TD><TD align="right"></TD><TD align="right"></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl22" height="17" style="height: 12.75pt;"></TD><TD align="right"></TD><TD align="right"></TD></TR></TBODY></TABLE><P>In this example, the user have choosen the Region X, which has a Size= 4.</P><P>The Cities from Region X with the Status=1 are ranked 18 within all The Cities with Status=1 from The Region_Size=4. The ranking-variable is the total households : SUM ( HH)</P><P>Sorry, it's a little bit tricky but maybe someone can help me.</P><P>Regards</P><P>Jean-Jacques</P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Tue, 18 Jan 2011 19:23:45 GMT 2011-01-18T19:23:45Z Ranking within a subset selected by a user https://community.qlik.com/t5/QlikView/Ranking-within-a-subset-selected-by-a-user/m-p/300331#M1202828 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>This issue gave me some difficulties. I need some help.</P><P>Suppose we have a file with this fields</P><P>- Region</P><P>- Region_Size (5 different values)</P><P>- City (a city belongs to a Region)</P><P>- City_Status (2 values 1 or 2)</P><P>- HH (households)</P><P>In my application, the user have to select a unique Region.</P><P>I want to display a chart (table) with this informations :</P><P>- City_Status</P><P>- The Rank of the Cities among all the Regions with the same Region_Size that my Selected Region</P><TABLE border="0" cellpadding="0" cellspacing="0" style="height: 51px;" width="227"><COL style="width: 60pt;" width="80" /><COL style="width: 58pt;" width="77" /><COL style="width: 53pt;" width="70" /><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl23" height="17" style="height: 12.75pt; width: 60pt;" width="80"><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3295_sourceID:3295" /></TD><TD class="xl23" style="width: 58pt;" width="77"></TD><TD class="xl24" style="width: 53pt;" width="70"></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl22" height="17" style="height: 12.75pt;"></TD><TD align="right"></TD><TD align="right"></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl22" height="17" style="height: 12.75pt;"></TD><TD align="right"></TD><TD align="right"></TD></TR></TBODY></TABLE><P>In this example, the user have choosen the Region X, which has a Size= 4.</P><P>The Cities from Region X with the Status=1 are ranked 18 within all The Cities with Status=1 from The Region_Size=4. The ranking-variable is the total households : SUM ( HH)</P><P>Sorry, it's a little bit tricky but maybe someone can help me.</P><P>Regards</P><P>Jean-Jacques</P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Tue, 18 Jan 2011 19:23:45 GMT https://community.qlik.com/t5/QlikView/Ranking-within-a-subset-selected-by-a-user/m-p/300331#M1202828 2011-01-18T19:23:45Z