topic Re: Display top 'x' rows and sum others in QlikView https://community.qlik.com/t5/QlikView/Display-top-x-rows-and-sum-others/m-p/359294#M574464 <HTML><HEAD></HEAD><BODY><P>This is a new feature in QV 11 that is Dimension limits.</P><P></P><P>Use can see this scenerio in the application "Whats New in QlikView11" in the tab "Sales Reps".</P></BODY></HTML> Tue, 19 Jun 2012 10:41:36 GMT 2012-06-19T10:41:36Z Display top 'x' rows and sum others https://community.qlik.com/t5/QlikView/Display-top-x-rows-and-sum-others/m-p/359292#M574462 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have following data on straight table, i am creating a "list box" top 'x' rows and others should sum up.</P><P>Straight table:</P><TABLE border="0" cellpadding="0" cellspacing="0" height="325" style="width: 196px;"><TBODY><TR><TD class="xl63" height="17" width="98">FS</TD><TD align="right" class="xl64" style="border-left: none;" width="98">732</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Tec</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">30</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Me</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">28</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Other</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">25</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">PS</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">14</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Edu</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Util</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">6</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Auto</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Con</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Gov</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Tel</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">4</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Hea</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">3</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Aer</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Agr</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Dive</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Man</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Retai</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Hos</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">1</TD></TR></TBODY></TABLE><P></P><P>the result shoud come as follow:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 184px;"><TBODY><TR><TD class="xl65" height="17" width="120">FS</TD><TD align="right" class="xl66" style="border-left: medium none;" width="64">732</TD></TR><TR><TD class="xl65" height="17" style="border-top: medium none;">Tec</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">30</TD></TR><TR><TD class="xl65" height="17" style="border-top: medium none;">Me</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">28</TD></TR><TR><TD class="xl65" height="17" style="border-top: medium none;">PS</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">14</TD></TR><TR><TD class="xl65" height="17" style="border-top: medium none;">Edu</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">10</TD></TR><TR><TD class="xl65" height="17" style="border-top: medium none;">Util</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">6</TD></TR><TR><TD class="xl65" height="17" style="border-top: medium none;">Others</TD><TD align="right" class="xl66" style="border-top: medium none; border-left: medium none;">58</TD></TR></TBODY></TABLE><P></P><P>can someone help me to get above result?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 19 Jun 2012 10:28:35 GMT https://community.qlik.com/t5/QlikView/Display-top-x-rows-and-sum-others/m-p/359292#M574462 2012-06-19T10:28:35Z Re: Display top 'x' rows and sum others https://community.qlik.com/t5/QlikView/Display-top-x-rows-and-sum-others/m-p/359293#M574463 <HTML><HEAD></HEAD><BODY><P>If you are using qv 11 you can use dimension limitis. </P></BODY></HTML> Tue, 19 Jun 2012 10:36:58 GMT https://community.qlik.com/t5/QlikView/Display-top-x-rows-and-sum-others/m-p/359293#M574463 2012-06-19T10:36:58Z Re: Display top 'x' rows and sum others https://community.qlik.com/t5/QlikView/Display-top-x-rows-and-sum-others/m-p/359294#M574464 <HTML><HEAD></HEAD><BODY><P>This is a new feature in QV 11 that is Dimension limits.</P><P></P><P>Use can see this scenerio in the application "Whats New in QlikView11" in the tab "Sales Reps".</P></BODY></HTML> Tue, 19 Jun 2012 10:41:36 GMT https://community.qlik.com/t5/QlikView/Display-top-x-rows-and-sum-others/m-p/359294#M574464 2012-06-19T10:41:36Z