Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

evansabres
Valued Contributor

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

Re: Limit Number of Rows Loaded

May be like this:

TableName:

First 1000

LOAD .....

FROM....;


or


TableName:

LOAD ...

FROM...

Where RowNo() <= 1000;

View solution in original post

3 Replies
rupamjyotidas
Valued Contributor

Re: Limit Number of Rows Loaded

There are some ways.

Load Top 10

Or

You can write a where statement like

Load *

From xyz.qvd where row()<100

Partner
Partner

Re: Limit Number of Rows Loaded

Yes ,

Debug option is there to load llimited numer of records

Re: Limit Number of Rows Loaded

May be like this:

TableName:

First 1000

LOAD .....

FROM....;


or


TableName:

LOAD ...

FROM...

Where RowNo() <= 1000;

View solution in original post