Discussion Board for collaboration on QlikView Scripting.
In my excel some records are there.
but i dont want to load first 1000 records.
How to solve this issue?
Go to Solution.
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
Try like this
for first 1000
for Greater then 1000
[yourexcel.xls] where rowno()>1000;
Load * From ExcelFile Where RecNo() <= 1000;
Then try this way for rows greater than 1000 rows.
Load * From
ExcelSource Where RecNo() > 1000;
ExcelSource Where RowNo() > 1000;