Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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 1Header 2
sai5236
anu7410
sbndjkh5263
nkhk8846
Harish54645
jhbyjhg548464
bhbvhbh534564
mvbhjvghk55343
bhbh5354
nmbjbjk53153

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..

1 Solution

Accepted Solutions

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

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


talk is cheap, supply exceeds demand
4 Replies

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

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


talk is cheap, supply exceeds demand
Not applicable

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

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

Not applicable

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

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

Not applicable

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

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

Community Browser