topic Table with only some rows in QlikView https://community.qlik.com/t5/QlikView/Table-with-only-some-rows/m-p/436395#M162769 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have to make a table (like attached file) in which the dimensions are: sex, age and type.</P><P>The expression is the frequency of each type.</P><P>How do I show only the first 2 (or 3..) rows for every Type.</P><P>For example I need to show only the rows (see table CountType):</P><P>Sex&nbsp;&nbsp;&nbsp;&nbsp; Age&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CounType</P><P>&nbsp;&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>&nbsp;&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>&nbsp;&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>&nbsp;&nbsp;&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>&nbsp;&nbsp;&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>&nbsp;&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>........................................</P><P></P><P>...&nbsp; and so on</P><P>How can I do it?</P><P></P><P>&nbsp;&nbsp; Thank</P><P>&nbsp;&nbsp; Sbuzi</P></BODY></HTML> Tue, 09 Apr 2013 13:08:40 GMT 2013-04-09T13:08:40Z Table with only some rows https://community.qlik.com/t5/QlikView/Table-with-only-some-rows/m-p/436395#M162769 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have to make a table (like attached file) in which the dimensions are: sex, age and type.</P><P>The expression is the frequency of each type.</P><P>How do I show only the first 2 (or 3..) rows for every Type.</P><P>For example I need to show only the rows (see table CountType):</P><P>Sex&nbsp;&nbsp;&nbsp;&nbsp; Age&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CounType</P><P>&nbsp;&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>&nbsp;&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>&nbsp;&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>&nbsp;&nbsp;&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>&nbsp;&nbsp;&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>&nbsp;&nbsp; F&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>........................................</P><P></P><P>...&nbsp; and so on</P><P>How can I do it?</P><P></P><P>&nbsp;&nbsp; Thank</P><P>&nbsp;&nbsp; Sbuzi</P></BODY></HTML> Tue, 09 Apr 2013 13:08:40 GMT https://community.qlik.com/t5/QlikView/Table-with-only-some-rows/m-p/436395#M162769 2013-04-09T13:08:40Z Re: Table with only some rows https://community.qlik.com/t5/QlikView/Table-with-only-some-rows/m-p/436396#M162770 <HTML><HEAD></HEAD><BODY><P>See <A _jive_internal="true" href="https://community.qlik.com/message/334328#334328">my reply</A> in your other discussion</P></BODY></HTML> Wed, 10 Apr 2013 16:00:55 GMT https://community.qlik.com/t5/QlikView/Table-with-only-some-rows/m-p/436396#M162770 Gysbert_Wassenaar 2013-04-10T16:00:55Z