Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Read excel from multiple subfolders

I am trying to read Excel files from multiple subfolders into QlikView. The only problem is I don't want to create multiple LOAD statments in the script and I do not always know the name of the subfolders.

The following load statement doesn't work. * should be a any subfolder in the folder


3 Replies
Not applicable


Try suggested script from this topic:


Or see 'Photo and Music' demo


Creator II
Creator II


What I have done in one of my app is that I maintain a separate xls with the list of all the locations and in the load script load the data from all the file in a loop to pick up all the files from the different locations. The location and name of the file is stored in a variable that I use in my load statement

Hope this helps.


Not applicable

Do you perhaps have some sample code?