Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

This is practice question

How can i load multiple excel sheets in to qv at a tile

4 Replies
gupta_n8
Valued Contributor II

Re: This is practice question

Yes Definately,

Actually you can use for loop statement to iterate all the sheets to load all sheets to qv at a time

Partner
Partner

Re: This is practice question

MVP
MVP

Re: This is practice question

LOAD *,

  FileName() as Excelnames

FROM

*.xlsx

(ooxml, embedded labels, table is [$(*)]);

Not applicable

Re: This is practice question