Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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