Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
inam
Contributor III
Contributor III

load sheet

Hello Community ,

I have 17 excel sheet month wise (Jan 2022 to may2023) how I load all sheet in QlikView?

for example:-

load

a,

b,

c,

FROM
[D:\QlikView_inam\data\At Group\vi. B2B Online Reports & vii. Sourcing Report\2nd dashboard\Data\Master Sales Overview Report 2023-06-01 (1).xls]
(html, codepage is 1252, embedded labels, table is @2);

load

a,

b,

c,

FROM
[D:\QlikView_inam\data\At Group\vi. B2B Online Reports & vii. Sourcing Report\2nd dashboard\Data\Master Sales Overview Report 2023-06-01 (2).xls]
(html, codepage is 1252, embedded labels, table is @2);

load

a,

b,

c,

FROM
[D:\QlikView_inam\data\At Group\vi. B2B Online Reports & vii. Sourcing Report\2nd dashboard\Data\Master Sales Overview Report 2023-06-01 (3).xls]
(html, codepage is 1252, embedded labels, table is @2);

have 17 excel sheet month wise (Jan 2022 to may2023) how I load all sheet in QlikView?

for example:-

load

a,

b,

c,

FROM
[D:\QlikView_inam\data\At Group\vi. B2B Online Reports & vii. Sourcing Report\2nd dashboard\Data\Master Sales Overview Report 2023-06-01 (4).xls]
(html, codepage is 1252, embedded labels, table is @2);

and so on till may2023 how i load all sheet in qlikview.

Labels (2)
1 Reply