Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
Contributor

Load Multiple Sheets from 1 excel file

I have different sheets in 1 excel file.

Each sheet represent one year data.

All the column and heading are same.

How do i load all sheets in Qliksense?

Please find attached as my scripting and excel sheets name.

ScriptingScriptingExcel Sheet NameExcel Sheet Name

 

Tags (2)
4 Replies
Highlighted
Valued Contributor III

Re: Load Multiple Sheets from 1 excel file

use

sheet1

concatenate

 

sheet2

Channa
Highlighted
Contributor

Re: Load Multiple Sheets from 1 excel file

@Channa 

Thanks for the suggestion.

The script would be really long and so much repetitive if i have lot of sheets.

Just wonder if there any better solution such as changing the last row of script.

Highlighted
Honored Contributor II

Re: Load Multiple Sheets from 1 excel file

You have to use a for loop to do that

you can check in the community and even if you find an answer for Qlikview you can change it for Qliksense

https://community.qlik.com/t5/New-to-QlikView/loading-all-sheets-data-from-excel/td-p/673784

https://community.qlik.com/t5/QlikView-Scripting/Load-data-from-multiple-worksheets-in-multiple-Exce...

Learning never stops.
Highlighted
Valued Contributor III

Re: Load Multiple Sheets from 1 excel file

if you have too many use loping suggested by @pradosh_thakur 

 

that URL's has full details 

 

Channa