Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Check this.
Load Multiple excel sheets using For loop
Loading Multiple Excel Sheets | Qlikview Cookbook
Regards,
Kaushik Solanki
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.