Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
evansabres
Specialist
Specialist

Limit Number of Rows Loaded

Is there a way within the scripting to limit the loading of data to the first 'X' number of rows?

1 Solution

Accepted Solutions
sunny_talwar

May be like this:

TableName:

First 1000

LOAD .....

FROM....;


or


TableName:

LOAD ...

FROM...

Where RowNo() <= 1000;

View solution in original post

3 Replies
rupamjyotidas
Specialist
Specialist

There are some ways.

Load Top 10

Or

You can write a where statement like

Load *

From xyz.qvd where row()<100

nagarjuna_kotha
Partner
Partner

Yes ,

Debug option is there to load llimited numer of records

sunny_talwar

May be like this:

TableName:

First 1000

LOAD .....

FROM....;


or


TableName:

LOAD ...

FROM...

Where RowNo() <= 1000;

View solution in original post