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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to display the top N in a straight table

Hi,

I have a table with 9 rows of data but I would like to display only the top 3.  Is there a simple piece of code for this?  I also have another table that I would like to show the bottom 3.  Thanks in advance.

6 Replies
Not applicable
Author

Hi,

Have'nt you tried by checking the "Max Number(1-100)" check box in Presentation tab in strainght table to 3 to display only the top 3 rows...,

Not sure about your scenario,but it will work to display  🙂

Not applicable
Author

checking the "Max Number(1-100)"  does not seem to be available for a Table Box

Not applicable
Author

and I'm using QV 9

Not applicable
Author

sorry I found it, will let you know how I get on

Not applicable
Author

oh sure

Not applicable
Author

@davieedw - also remember to sort Ascending for Top x and Descending for bottom x when using the "Max Number 1-100) option.