Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error Handling

So I need to know how to load all the tabs or sheets from a single excel file the loop I have now will fail if one month is missing and the only way I can get it to work is breaking up the loop and I really don't think that is an option because we will have more years and that eliminates the possibility of if they put that month back.

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Check this.

Load Multiple excel sheets using For loop

Loading Multiple Excel Sheets | Qlikview Cookbook

Regards,
Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anonymous
Not applicable
Author

That is the code I'm using or at least a variant of it. Unfortunately qlik used to have a simpler way to do this and it stopped working which is why I'm in this predicament.