Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
berstrom
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
pianoman15
Contributor II
Contributor II

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
pianoman15
Contributor II
Contributor II

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