Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

excel

Hi,

In my excel some records are there.

but i dont want to load first 1000 records.

How to solve this issue?

Regards

Anil

1 Solution

Accepted Solutions

Re: excel

Hi Anil,

By RecNo() <= 1000 you get only records from 1 to 1000 did you check the result of this expression it should be RecNo() > 1000.

Just for curiosity

Regards

Anand

4 Replies

Re: excel

Hi,

Try like this

for first 1000

First 1000

LOAD *

FROM

[yourexcel.xls];

for Greater then 1000

LOAD *

FROM

[yourexcel.xls] where rowno()>1000;

Regards

ASHFAQ

anbu1984
Honored Contributor III

Re: excel

Load * From ExcelFile Where RecNo() <= 1000;

Re: excel

Hi,

Then try this way for rows greater than 1000 rows.

Load * From

ExcelSource Where RecNo() > 1000;

Or

Load * From

ExcelSource Where RowNo() > 1000;

Regards

Anand

Re: excel

Hi Anil,

By RecNo() <= 1000 you get only records from 1 to 1000 did you check the result of this expression it should be RecNo() > 1000.

Just for curiosity

Regards

Anand