topic Top x Percent in QlikView https://community.qlik.com/t5/QlikView/Top-x-Percent/m-p/271137#M1185330 <HTML><HEAD></HEAD><BODY><P>Hi guys having a bit of a strugle resolving a problem, lets say i have this table:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="252" style="height: 180px; width: 161px; border-width: 1px; border-color: #000000; border-style: solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Company<BR /></STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Revenue<BR /></STRONG></TH></TR><TR><TD>A</TD><TD>200</TD></TR><TR><TD>B</TD><TD>150</TD></TR><TR><TD>C</TD><TD>130</TD></TR><TR><TD>D</TD><TD>110</TD></TR><TR><TD>E</TD><TD>90</TD></TR><TR><TD>F</TD><TD>80</TD></TR><TR><TD>G</TD><TD>60</TD></TR><TR><TD>H</TD><TD>30</TD></TR><TR><TD>I</TD><TD>20</TD></TR><TR><TD>J</TD><TD>10</TD></TR></TBODY></TABLE><P>Now the total is 880 and im after a table that will show me Companies based on 80% of the top Revenues, 80% is 704, so basically my table would show me from company A to company F, that would make 760 thus showing me all the Companies that make at least 80% of the Revenue.</P><P></P><P>Many Thanks</P></BODY></HTML> Mon, 24 Oct 2011 17:12:03 GMT 2011-10-24T17:12:03Z Top x Percent https://community.qlik.com/t5/QlikView/Top-x-Percent/m-p/271137#M1185330 <HTML><HEAD></HEAD><BODY><P>Hi guys having a bit of a strugle resolving a problem, lets say i have this table:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="252" style="height: 180px; width: 161px; border-width: 1px; border-color: #000000; border-style: solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Company<BR /></STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Revenue<BR /></STRONG></TH></TR><TR><TD>A</TD><TD>200</TD></TR><TR><TD>B</TD><TD>150</TD></TR><TR><TD>C</TD><TD>130</TD></TR><TR><TD>D</TD><TD>110</TD></TR><TR><TD>E</TD><TD>90</TD></TR><TR><TD>F</TD><TD>80</TD></TR><TR><TD>G</TD><TD>60</TD></TR><TR><TD>H</TD><TD>30</TD></TR><TR><TD>I</TD><TD>20</TD></TR><TR><TD>J</TD><TD>10</TD></TR></TBODY></TABLE><P>Now the total is 880 and im after a table that will show me Companies based on 80% of the top Revenues, 80% is 704, so basically my table would show me from company A to company F, that would make 760 thus showing me all the Companies that make at least 80% of the Revenue.</P><P></P><P>Many Thanks</P></BODY></HTML> Mon, 24 Oct 2011 17:12:03 GMT https://community.qlik.com/t5/QlikView/Top-x-Percent/m-p/271137#M1185330 2011-10-24T17:12:03Z Re: Top x Percent https://community.qlik.com/t5/QlikView/Top-x-Percent/m-p/271138#M1185332 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You can add a pareto selection button.</P><P>Look at the example.</P><P></P><P>If you clik on the button, it selects the company which achive 80% of the overall revenue !</P><P></P><P>JJ</P></BODY></HTML> Mon, 24 Oct 2011 19:36:17 GMT https://community.qlik.com/t5/QlikView/Top-x-Percent/m-p/271138#M1185332 2011-10-24T19:36:17Z Re: Top x Percent https://community.qlik.com/t5/QlikView/Top-x-Percent/m-p/271139#M1185334 <HTML><HEAD></HEAD><BODY><P>Many Thanks exactly what i was looking for.</P></BODY></HTML> Mon, 24 Oct 2011 20:13:22 GMT https://community.qlik.com/t5/QlikView/Top-x-Percent/m-p/271139#M1185334 2011-10-24T20:13:22Z