Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table with only some rows

Hi all,

I have to make a table (like attached file) in which the dimensions are: sex, age and type.

The expression is the frequency of each type.

How do I show only the first 2 (or 3..) rows for every Type.

For example I need to show only the rows (see table CountType):

Sex     Age     Type      CounType

   F     10         A2          5

   F     10         A1          2

   F     11         A3          4

    F     11         A2          1

    F     12         A3          2

   F     12         A5          2

........................................

...  and so on

How can I do it?

   Thank

   Sbuzi

0 Replies