How to get First five rows in a straight table???

[#1]

Hi Qlikies,

I am new to Qlikview.. My purpose here is to get top 5 rows in a straight table..

Actually if we do like this in edit script we'll get a new field right?

SELECT TOP 5 * FROM TABLENAME;

but thats not the thing I want.

For example the following is a straight table..

Header 1	Header 2
sai	5236
anu	7410
sbndjkh	5263
nkhk	8846
Harish	54645
jhbyjhg	548464
bhbvhbh	534564
mvbhjvghk	55343
bhbh	5354
nmbjbjk	53153

So here I want Details only upto Harish...for that what expression we have to use??

Or what we have to do??

Thank you all...Please Help and do reply

Soon reply is appreciated..

[Gysbert_Wassenaar · Accepted solution]

On the Presentation tab of the properties screen set Max Number (1-100) to 5. Then only 5 rows will be shown.

[#3]

Oh wow thank you so much Gysbert...!!

[#4]

if u use qv11 then

dimension limits tab 

check the check box and give ur required values

if u give 5 then it display upto top 5 values

[#5]

oh yeah Both of your answers are working ..Thank you..!!