Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Load specific rows from data

Hey!

How can I load specific rows from an excel dataset, like for example rows 10 to 15?

Best regards

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Contributor
Contributor

Something like this?

LOAD A
FROM
Excel.xlsx
(ooxml, no labels, table is Sheet1)
where RecNo()>=10 AND RecNo()<=15
;

View solution in original post

1 Reply
Highlighted
Contributor
Contributor

Something like this?

LOAD A
FROM
Excel.xlsx
(ooxml, no labels, table is Sheet1)
where RecNo()>=10 AND RecNo()<=15
;

View solution in original post