Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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 - Specialist II
Partner - Specialist II

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;