Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Dynamically loading Excel sheets?

Hi Everyone,

I have a requirement where we need to load sheet n excel files dynamically.

For 2016 file we have sheet names like Jan, feb ..... dec

For 2017 file we have sheet names like Jan, feb ..... dec

but in 2018 sheets names are only from Jan to Aug and next month we will receive Sep.

Qlik is loading fine till 2018 Aug, but it gives error since Sept file is not available.

Can anyone please help me to load files incrementally with all sheets.

Thanks